Forum Discussion
Solved
Relative Date issues
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 month...
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
