Convert DAX to M Code

[JohnNPBIUser]

Hi,

I am trying to add a column via Power Query M.  How do I convert this DAX code to M language:

IF (
YEAR ( 'Dummy Data'[Admissions Month] )
= YEAR ( DATE(YEAR(TODAY()),

MONTH(TODAY())-1,DAY(TODAY())) )
&& MONTH ( 'Dummy Data'[Admissions Month] ) = MONTH ( DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())) ),
"Last Month",
'Dummy Data'[Admissions Month]
)

Thanks for your help.

[JohnNPBIUser]

Thank you for your help, much appreciated  👍

[BA_Pete · Accepted solution]

Hi @JohnNPBIUser ,

I think you can hugely simplify this down to:

if Date.StartOfMonth([AdmissionsMonth]) = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()), -1))
then "Last Month"
else [AdmissionsMonth]

Pete