Forum Discussion

Srikantht's avatar
Srikantht
Helper II
2 years ago
Solved

Previous Month Calculation getting Wrong

Hi All,   I am trying to get previous month values by using the below dax but getting wrong values. Can any one help in this to get the expected output. Thanks in Advance.    Dax :  Previo...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Srikantht ,

    Please try create a measure with below dax formula, but you need adjust it according to your actua calculate context:

    Previous month =
VAR cur_date =
    SELECTEDVALUE ( 'Table'[Date] )
VAR _result =
    CALCULATE (
        MAX ( [Current Month] ),
        FILTER ( ALL ( 'Table' ), DATEDIFF ( cur_date, [Date], MONTH ) = -1 )
    )
RETURN
    _result

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Srikantht 
Try below dax:
Prev Month= calculate( sum(value), dateadd(Date,-1,Month))

If  my post helps you. please give kudos and accept it as a solution!

  • Srikantht's avatar
    Srikantht
    Helper II
    2 years ago

    Sorry, it's not working.

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi Srikantht 
      what answer you are getting??
      I am getting the correct result through Dateadd function


      If my post helps give kudos and accept it as solution!

       

      • Srikantht's avatar
        Srikantht
        Helper II
        2 years ago

        I am getting same as current month output. 

         

        My dax : Previous Month = CALCULATE(SUM(Table[Value]),DATEADD('CALENDAR'[Date],-1,MONTH))