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 want to create a table which the values are accumlating (see sample below) but i could not get the correct visual to use. I hope you can help me on this.
PIVOT TABLE:
5/21/2018 | 1326 | 231 |
5/22/2018 | 12803 | 46105 |
5/23/2018 | 28641 | 7931 |
5/24/2018 | 34042 | |
5/25/2018 |
The table i want to create in Power BI.
5/21/2018 | 1326 | 231 |
5/22/2018 | 14129 | 46336 |
5/23/2018 | 42770 | |
5/24/2018 | 76812 | |
5/25/2018 | 76812 |
Solved! Go to Solution.
1. Check the format
2. It will solved using Cumm. Total
1. Check the format
2. It will solved using Cumm. Total
@Anonymous,
You may simply use Quick measure Running total.
I already use the running total but it seems that the total on the previous date does not sum up the next one. It always shows the "count" instead.
@Anonymous,
Check the data type and do not select Date Hierarchy.
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |