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.
I need a formula for the Cumulative of the "Minut" evety time we change the event number.
EVENT Minut Cumulative
97 2 5
97 3 5
98 18 24
98 2 24
98 1 24
98 3 24
99 6 11
99 4 11
99 1 11
What is the recommended simple DAX for such operation?
Solved! Go to Solution.
@Anonymous
If you wish to see all the rows, you will need to add an index column to your table (otherwise the values get aggregated by "Event")
The try this measure to get the aggregate for each event:
Total by Event = CALCULATE([Sum of Minut]; ALLEXCEPT(Table1; Table1[Event]))
To get the actual cumulative :
Cumulative = CALCULATE([Sum of Minut];
FILTER(ALL(Table1);
Table1[Event]<=MAX(Table1[Event]))
)
And this is the result:
Proud to be a Super User!
Paul on Linkedin.
Hi @elmorlc,
You can create one measure as below:
Cumulative = CALCULATE(SUM('Events'[Minut]),ALLEXCEPT('Events','Events'[EVENT]))
Best Regards
Rena
Hi @elmorlc,
You can create one measure as below:
Cumulative = CALCULATE(SUM('Events'[Minut]),ALLEXCEPT('Events','Events'[EVENT]))
Best Regards
Rena
@Anonymous
If you wish to see all the rows, you will need to add an index column to your table (otherwise the values get aggregated by "Event")
The try this measure to get the aggregate for each event:
Total by Event = CALCULATE([Sum of Minut]; ALLEXCEPT(Table1; Table1[Event]))
To get the actual cumulative :
Cumulative = CALCULATE([Sum of Minut];
FILTER(ALL(Table1);
Table1[Event]<=MAX(Table1[Event]))
)
And this is the result:
Proud to be a Super User!
Paul on Linkedin.
Create a new column
New column = sumx(filter(table,table[EVENT]=earlier(table[EVENT])),table[Minut])
Appreciate your Kudos.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |