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 s...
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
    )
techies's avatar
techies
Super User
1 year ago

Hi JemmaD DATEDIFF like this

 

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