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
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
