Forum Discussion
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 this in Query Editor?
or this
if Date.EndOfMonth([Date]) = Date.EndOfMonth( List.Max(#"Changed Type"[Date])) then 1 else 0
