Forum Discussion

JemmaD's avatar
JemmaD
Helper V
1 year ago
Solved

Calculated Column for Months from Today

I need to create a calculated DAX column to tell me the number of months from today. 

So any rows where the date is in this month for example would show 0

Rows for last month would be 1

Rows for six months ago would be 6

Next month I guess would be -1

 

I tried this but without the year included it doesn't work once we get to the previous year

= MONTH(TODAY()) - MONTH([DATE])+1

 

Need Help
  • techies's avatar
    techies
    1 year ago

    Hi JemmaD DATEDIFF like this

     

    MonthsFromToday =
    DATEDIFF (
        DATE(YEAR([Date]), MONTH([Date]), 1),
        DATE(YEAR(TODAY()), MONTH(TODAY()), 1),
        MONTH
    )