Previous Month Calculation getting Wrong

[Srikantht]

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

[Anonymous · Accepted solution]

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]

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]

Sorry, it's not working.

[Uzi2019]

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]

I am getting same as current month output. 

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

[Uzi2019]

hi  @Srikantht 
Try his measure

If my posy helps please give kudos and accept it  as a solution!
Thanks.