Create if then clause with greater than or less than comparing dates

[Anonymous]

I have two columns with dates that I would like to compare and create a new custom column in Power Query.

What I want do do is is determine if the [Date] is <= to [Date End of Month]. If it's <= then I want to display "Less than current month" if it's > then I want to display "Greater than current month"

How do I create this custom column?

[edhans · Accepted solution]

Hi @Anonymous Try this formula. It returns this, today being July 28, 2020.

=if [Date] >= Date.EndOfMonth(DateTime.Date(DateTime.LocalNow())) then "Greater than Current Month" else "Less than Current Month"

[Anonymous]

here you can find the functions that could help you to get the result

https://docs.microsoft.com/it-it/powerquery-m/date-isincurrentmonth

[Anonymous]

Thank you, I actually used those formulas to create some other columns...but I'm not clear how to create an if then clause using >= to compare columns. Any ideas how to an if then comparing columns?