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
Fabric Community Sticker Challenge - Barcelona 2026
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
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.
