Relative Date issues

[rpinxt]

I am filtering to see last 13 months:

I can see the dates but why does it do this?

Its Oct 23 now sow 13 months I would expect Sep 22 to Oct 23. So full months.

But I don't get full months:

Filtered

Without filter:

So relative date will not work to get full months? Only at the end of month october 23?

[Villezekeviking]

I now this is already solved but I'm offering an alternative solution for those who might search and find this thread.

https://www.villezekeviking.com/dax-tables-calendar-and-time/

I have offset-columns from today that can be used to filter any report relative from today on days, weeks, months, quarters or years.

Unlike the relative date filtering, this can span any period, from historical data, over current periods and into the future.

You can use this in your scenario to filter on months to get full calendar months.

-1 is prev month, -2 the month before that etc.

[rpinxt]

Thanks @danextian !

Was able to add this rolling month field into my autocalendar and now can use it to filter the page.

Now I get Oct 23 to Sep 22 (full month) 😄

[danextian · Accepted solution]

Hi @rpinxt ,

The last x months relativie date filter  is relative to the current day and does not include full months. The last x calendar months does  include the full months but not if the current month if it isn't complete yet. You can create a calculated column to calculate the for the number of months  from today, the current month being month 1 and the previous month being month 2, etc. Here's a sample formula:

Rolling Months from Today = 
DATEDIFF ( Dates[Date], TODAY (), MONTH ) + 1