M Language Power Query Editor create Flag for Last Month and another Flag for month before that

[DebbieE]

In my date dimension I have a current date set

Ive made a currently month flag from that

Is there any way in M that I can create a flag against last month dates

And then go onto make a flag against the month two months ago?

I did it by copying the column twice and changing them to Month and year.

Anoyingly you cant simply subtract 1 from month because if you are at 12 it has to go back to 1

Any help would be appreciated

[mwegener · Accepted solution]

Hi @DebbieE ,

check this.

https://docs.microsoft.com/en-us/powerquery-m/date-isinpreviousnmonths

[DebbieE]

Unfortunately it hasnt worked 

Date.IsInPreviousMonth(Date.AddMonths(DateTime.FixedLocalNow(), -1))

I have added this into Power Query Editor but its setting every row in my date dimension as True

I know what Im doing wrong  I want the actual date from my date dimension. Not the current date.

Changed it to Date.IsInPreviousMonth(Date.AddMonths([Date], -1)) Here's hoping this one works

[DebbieE]

Perfect. Thankyou so much