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 by yearmonth, it is giving me same results for all yearmonth in table    pbix:  https://drive.google.com/file/d/1-3eT8k82RvT...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    powerbiexpert22 , Try using below measure

     

    PromotersRollingCount =
    CALCULATE(
        COUNT(survey2[Promoters]),
        DATESINPERIOD(
            'Date'[Date],
            LASTDATE('Date'[Date]),
            -3,
            MONTH
        )
    )
bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

powerbiexpert22 , Try using below measure

 

PromotersRollingCount =
CALCULATE(
    COUNT(survey2[Promoters]),
    DATESINPERIOD(
        'Date'[Date],
        LASTDATE('Date'[Date]),
        -3,
        MONTH
    )
)