Forum Discussion

adam_mac's avatar
adam_mac
Icon for Helper I rankHelper I
5 years ago
Solved

Yesterdays 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(...
Help Requested
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

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

     

     

     

     

     

     

Arentir's avatar
Arentir
Icon for Resolver III rankResolver III
5 years ago

Just a teeny tiny parenthesis in the wrong place 🙂

MONTH(TODAY())-1

 

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

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