Forum Discussion

Naveen29's avatar
Naveen29
Helper II
4 years ago
Solved

DAX Help

How to calcuulate the last 13 Months based on Year & month selection from slicer?   I have a line chart displaying revenue vs month
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

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.