Solved: Re: Yesterdays Date Prior Month

adam_mac · ‎08-23-2021

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

PaulDBrown · ‎08-23-2021

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

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Arentir · ‎08-23-2021

Just a teeny tiny parenthesis in the wrong place 🙂

MONTH(TODAY())-1

PaulDBrown · ‎08-23-2021

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

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Yesterdays Date Prior Month