DAX Help

[Naveen29]

How to calcuulate the last 13 Months based on Year & month selection from slicer?

I have a line chart displaying revenue vs month

[v-chenwuz-msft · Accepted 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.

[aj1973]

Hi @Naveen29 

this video should help you out

https://www.youtube.com/watch?v=d8Rm7dwM6gc&t=336s