Yesterdays Date Prior Month

[adam_mac]

Hi, i am trying to create simple DAX formula for yesterdays last month however below seems to not work. Not sure where i am going wrong. Any ideas?

DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY()-1))

[Arentir]

Just a teeny tiny parenthesis in the wrong place 🙂

MONTH(TODAY())-1

[PaulDBrown · Accepted solution]

You might have issues when the month is January, & for DAY(TODAY()) = 1 of the month and for march vs february?

If you have a calendar table you can try:

current date Last month = CALCULATE(MAX('Calendar Table'[Date]), DATEADD('Calendar Table'[Date], -1,MONTH))

Final yesterday Last month = 
CALCULATE([current date Last month], FILTER(ALL('Calendar Table'), 'Calendar Table'[Date] = TODAY() -1))