I receive weekly published values on a specific day, and I also have a date range. I need to display previous (Actual PAX) values from the beginning of the month up to the latest uploaded values.
I've tried using fixed methods and adjusting the date range, but it hasn't produced the desired outcome.
Can someone assist me with this?
I don't quite follow, but it looks from your image like you want to populate the cells of data in Tableau that are empty (not null) in your data / the image below:
I'd recommend using a scaffold of your forecast published dates, so that you can test for NULL and then populate the value only if it is NULL. You can't do it with an LOD, because you're FIXED at the date level, which means you can only see what is on rows of data for that date, you can't 'scan' the data for other dates that fulfil a criterion.
