Calculated Column with IF in Query Editor

[aashton]

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?

[aashton]

@Ahmedx  Thank you!!

[Ahmedx · Accepted solution]

or this

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

[Ahmedx]

try this