Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago
Solved

rolling count

i am trying to create line chart to show the rolling count of promoters for last 3 months by yearmonth, it is giving me same results for all yearmonth in table    pbix:  https://drive.google.com/f...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi powerbiexpert22 can you try below measure 

     

    PromotersRolling3Months =
    VAR CurrentYearMonth = MAX('Date'[YearMonth])
    RETURN
    CALCULATE(
        [Promoters],
        DATESINPERIOD(
            'Date'[Date],
            MAX('Date'[Date]),
            -3,
            MONTH
        )
    )

     

    Hope it works

     

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi powerbiexpert22 can you try below measure 

 

PromotersRolling3Months =
VAR CurrentYearMonth = MAX('Date'[YearMonth])
RETURN
CALCULATE(
    [Promoters],
    DATESINPERIOD(
        'Date'[Date],
        MAX('Date'[Date]),
        -3,
        MONTH
    )
)

 

Hope it works