I am able to find it using: {Fixed Datepart('month', [Week Of]): MAX([Week Of])}
But the LOD is messing with the calculations i need to run.
Any help is appreciated!
10 answers
My data uses "week's of" for date. That LOD function gives me te last "Week of" per month. However, I need to show a rolling 4 weeks from that date (column 2).
Because the first column is fixed, the second column will not show a week in the previous month, For example, if we look at 07-25-2022, that should also include 06-27-2022, but it cant because its fixed. I thought this was a general Tableau limitation but it is not. I tried manually showing rolling 4 weeks from a manually ccreated date of 07-25-2022, and it worked.
