comparison between columns

[kasife]

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               11/2022                          <    10/2022    then null 

I would like to compare month and year only, without full date

[kasife]

@Ahmedx  than you so much

[Ahmedx · Accepted solution]

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"