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 : 

Previous Month = CALCULATE(SUM(value),
ALL(Table),
PREVIOUSMONTH(Table[Date]))

 

 

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.

6 Replies

  • 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!

      • 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!

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.