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.
Hi, im not sure if this is possible so hope someone can give some answer on it.
I have a measure and it results in this:
However i need the running total / cummulate the amounts... in this case :
days after today 44,88,132,176, etc etc ...
I thought by using this part i should be able to cummulate all the previous numbers :
"DIM_Dates[Date] >= maxdate,
Your variable MA is fixed once calculated, so putting it inside the CALCULATE doens't get you new numbers. Try deleting that variable and replace MA with whatever your desired calculation is (e.g., SUM of a column?) in your Return.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I tried that but also doesnt get me the result.
Maybe better to decribe the total calculations/measures:
1) I have a measure that counts the nrs of rows in a (filtered) table. (measure 1)
2) from that measure i calculate the 30days MA (measure 2)
measure2=
2) from that measure i want to have the running totals starting today, just like here https://www.sqlbi.com/articles/computing-running-totals-in-dax/ (Runningtotal)
Runningtotal=
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |