Solved: DAX Help

Naveen29 · ‎11-16-2021

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 · ‎11-18-2021

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.

View solution in original post

v-chenwuz-msft · ‎11-18-2021

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.