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.
Hey guys,
I'm newish to Power BI and I'm trying to get a running totla function for the last 12 weeks or so (length of time is less important). I have this DAX function for a measure and it returned what I want except it also tacks on the last two months of data in my dataset for some reason, and it just repeats the same cummulative value (49308 everyday for two months). If you guys could take a look at it and tell me what you think the issue is that would be great.
Running Total =
CALCULATE(
SUM(Sheet2[Sales]),
FILTER (
ALL( Sheet2 ),
MAX ( Sheet2[Date] ) <= Today()
&& Sheet2[Date].[Date] <= MAX ( Sheet2[Date].[Date] )),
DATESINPERIOD (
Sheet2[Date],
Today(),
-84,
DAY
)
)
Solved! Go to Solution.
There is a Quick Measure for Running Totals. You will want a separate Calendar table to use those. I also have a Running Weeks Quick Measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Weeks/m-p/391694
There is a Quick Measure for Running Totals. You will want a separate Calendar table to use those. I also have a Running Weeks Quick Measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Weeks/m-p/391694
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |