Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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]))
Solved! Go to 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.
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.
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!
Sorry, it's not working.
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!
I am getting same as current month output.
My dax : Previous Month = CALCULATE(SUM(Table[Value]),DATEADD('CALENDAR'[Date],-1,MONTH))
hi @Srikantht
Try his measure
If my posy helps please give kudos and accept it as a solution!
Thanks.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
92 | |
86 | |
69 |
User | Count |
---|---|
160 | |
125 | |
116 | |
110 | |
95 |