Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How to calcuulate the last 13 Months based on Year & month selection from slicer?
I have a line chart displaying revenue vs month
Solved! Go to Solution.
Hi @Naveen29 ,
Please try some measures like this :
Last 13 month =
VAR _s =
MIN( 'Table'[Year/Month] )
VAR _result =
CALCULATE(
SUM( 'Table'[value] ),
FILTER(
ALL( 'Table' ),
[Date]
>= DATE( YEAR( _s ), MONTH( _s ) - 13, 1 )
&& [Date] < _s
)
)
RETURN
_result
OR share some example data without sensitive data and I will help you.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Naveen29 ,
Please try some measures like this :
Last 13 month =
VAR _s =
MIN( 'Table'[Year/Month] )
VAR _result =
CALCULATE(
SUM( 'Table'[value] ),
FILTER(
ALL( 'Table' ),
[Date]
>= DATE( YEAR( _s ), MONTH( _s ) - 13, 1 )
&& [Date] < _s
)
)
RETURN
_result
OR share some example data without sensitive data and I will help you.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Naveen29
this video should help you out
https://www.youtube.com/watch?v=d8Rm7dwM6gc&t=336s
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |