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.

2 Replies

  • 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.