Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Thanks
@VikramAdi Please provide sample data and expected output because I'm not understanding what you want.
Thanks
@VikramAdi As far as I can tell, the cumulative measure is returning correct results. Check out the table in the image. The cumulative measure is adding up the 30 day averages as it goes. So, the question becomes, what do you want the results to be? Because the cumulative measure is doing exactly what it is supposed to do. I attached the PBIX file below signature.
@VikramAdi So like this?
Cumulative Measure =
VAR __Date = MAX('Date'[Date])
VAR __Table = SUMMARIZE(FILTER(ALL('Dates'),[Date]<=__Date),[Date],"__30Avg",[Rolling 30 Days Average])
VAR __Result = SUMX(__Table,[__30Avg])
RETURN
__Result
@VikramAdi Sorry, what do you mean by cumulative rolling 30 day average? Do you mean that 30 days ago just 1 day is displayed, 29, 2 days, 28, 3, etc?
Better Rolling Average - Microsoft Power BI Community
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |