Forum Discussion
adam_mac
Helper I
Helper IYesterdays Date Prior Month
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))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))
2 Replies
ArentirResolver III
Just a teeny tiny parenthesis in the wrong place 🙂
MONTH(TODAY())-1
PaulDBrownCommunity Champion
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))