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()
)
1 ACCEPTED SOLUTION
@powerbiexpert22 , Try using below measure
PromotersRollingCount =
CALCULATE(
COUNT(survey2[Promoters]),
DATESINPERIOD(
'Date'[Date],
LASTDATE('Date'[Date]),
-3,
MONTH
)
)
Proud to be a Super User! | 
|
@powerbiexpert22 , Try using below measure
PromotersRollingCount =
CALCULATE(
COUNT(survey2[Promoters]),
DATESINPERIOD(
'Date'[Date],
LASTDATE('Date'[Date]),
-3,
MONTH
)
)
Proud to be a Super User! |
|
Helpful resources
Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
