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
Power BI Monthly Update - September 2024
Check out the September 2024 Power BI update to learn about new features.
Microsoft Fabric & AI Learning Hackathon
Learn from experts, get hands-on experience, and win awesome prizes.
Fabric Community Update - September 2024
Find out what's new and trending in the Fabric Community.
