Forum Discussion
Solved
comparison between columns
Guys, in the M language, how could I get just the month and year of each column so that I can perform a comparison? For exemplo: (Column data_alteracao_status) (CreatedDate) if ...
in case of no less I wrote "OK". instead you can paste what you want
if Number.From(Date.ToText( Date.From([data_alteracao_status]),[Format= "yyyyMM"])) < Number.From(Date.ToText( Date.From([CreatedDate]),[Format= "yyyyMM"])) then null else "OK"
