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 all,
The table i am working with only the first four columns. How do I go about filtering the table by "Department", "Team", "Quarter" and getting the cumulative total in a new column as shown below.
Department----- | Team----- | Quarter----- | Items sold----- | Cumulative total of items sold |
Department A | Team 1 | Q1 | 30 | 30 |
Department A | Team 1 | Q2 | 22 | 52 |
Department A | Team 1 | Q3 | 10 | 62 |
Department A | Team 1 | Q4 | 13 | 75 |
Department A | Team 2 | Q1 | 10 | 10 |
Department A | Team 2 | Q2 | 12 | 22 |
Department A | Team 2 | Q3 | 6 | 28 |
Department A | Team 2 | Q4 | 2 | 30 |
Department B | Team 3 | Q1 | 1 | 1 |
Department B | Team 3 | Q2 | 3 | 4 |
Thank you,
chq
@Anonymous , if you need a new column
sumx(filter( Table, [department] = earlier([department]) && [Team] = earlier([Team]) && [Quarter] <= earlier([Quarter]) ), [item Sold] )
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
or you can measure using new window function
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |