Calculated Column for Months from Today

[JemmaD]

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

[techies · Accepted solution]

Hi @JemmaD DATEDIFF like this

MonthsFromToday =

DATEDIFF (

    DATE(YEAR([Date]), MONTH([Date]), 1),

    DATE(YEAR(TODAY()), MONTH(TODAY()), 1),

    MONTH

)

[ryan_mayu]

do you want to create a column or a measure? could you pls provide some sample data and expected output?

[lbendlin]

PLease use the DATEDIFF function (DAX) - DAX | Microsoft Learn