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.
Rep office | status | cost |
A2 | processing | 1902 |
A2 | processing | 8721 |
A9 | overdue | 1921 |
A2 | processed | 2001 |
A2 | processed | 2213 |
A9 | processed | 22113 |
A5 | processing | 2213 |
A2 | processing | 4343 |
A5 | Overdue | 2321 |
A2 | closed | 1123 |
A5 | closed | 9382 |
A5 | closed | 8382 |
A5 | processing | 912 |
i have a data like this and i want to calculate same name values from status column and than add the cost of that all values for example rep office of A2 have a processing status of 3 times and i need to add that all3 processing cost 1902+8721+4343
than A2 have a status of processed 2 times taht cost 2001+2213=4214and my end result or graph should be like this
Rep office closed overdue processed processing
A2 1123 - 4214 14966
A5
A9
..
which query or expression i need to enter thanks
Solved! Go to Solution.
Hi @Muavia,
You need a Matrix. Place [Rep office] in "Rows", [status] in "Columns" and [cost] in "Values".
Best regards,
Yuliana Gu
Hi @Muavia,
You need a Matrix. Place [Rep office] in "Rows", [status] in "Columns" and [cost] in "Values".
Best regards,
Yuliana Gu
Use Power Query editor.
select the 'status' column.
Click ''Pivot Column', select 'cost' in the dropdown when it appears. Click ok
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |