Forum Discussion

aashton's avatar
aashton
Helper V
2 years ago
Solved

Calculated Column with IF in Query Editor

I have a large spreadsheet I am bringing into my report, and I only need the last month of data.  In DAX, it would be  IF([Month Year]=MAX([Month Year]), 1, 0)   What is the correct syntax to do t...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    or this

    if Date.EndOfMonth([Date]) = Date.EndOfMonth( List.Max(#"Changed Type"[Date])) then 1 else 0

Ahmedx's avatar
Ahmedx
Super User
2 years ago

or this

if Date.EndOfMonth([Date]) = Date.EndOfMonth( List.Max(#"Changed Type"[Date])) then 1 else 0