I would like to use the out of the box relative date filters in my report however we use a calendar which ends months on the last sunday. This means that it could be a 4 4 5 or a 5 4 4 or a 4 5 4.
My model as it stands uses a Relative date table with a bidirectional relationship to the date table and really works very well. As i start adding in measure though i am tripping over problems with non contiguity in my formulas even when i envoke ALL(RELATIVE_DATE). The best solution would be an out of the box one but i cant figure out how to make the filter show the last month (Jan 2018) as ending on the 28th rather than the 31st. Any ideas?
// if this is a solution please mark as such. Kudos always appreciated.
