rolling count

[powerbiexpert22]

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

)

[bhanu_gautam · Accepted solution]

@powerbiexpert22 , Try using below measure

PromotersRollingCount =

CALCULATE(

    COUNT(survey2[Promoters]),

    DATESINPERIOD(

        'Date'[Date],

        LASTDATE('Date'[Date]),

        -3,

        MONTH

    )

)