Relative date

[samdthompson]

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?

[v-chuncz-msft · Accepted solution]

@samdthompson,

You may check if the following link helps.

http://community.powerbi.com/t5/Desktop/Report-on-Current-Calendar-Month-Excluding-Today/m-p/346431#...