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-3eT8k82RvTSem4EbzZJ_OlUU-A_PiMo/view?usp=drive_link

 

 

 

promotersrolling2 =

calculate(
    survey2[Promoters],
'Date'[Date]>=EDATE(TODAY(),-3)

&&
'Date'[Date]<=TODAY()
)

 

 

 

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
        )
    )

1 Reply

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