topic Re: Yesterdays Date Prior Month in DAX Commands and Tips

Yesterdays Date Prior Month

adam_mac — Mon, 23 Aug 2021 14:19:23 GMT

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 — Mon, 23 Aug 2021 15:05:03 GMT

Just a teeny tiny parenthesis in the wrong place 🙂

MONTH(TODAY())-1

PaulDBrown — Mon, 23 Aug 2021 17:42:10 GMT

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))