Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
2 years ago
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...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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

     

danextian's avatar
danextian
Super User
2 years ago

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