Forum Discussion
Substract Total count from specific event
Hello All,
I have below Data
| Number | Category | Event |
| 123 | UN | MV1 |
| 124 | UN | MV2 |
| 128 | IM | MB1 |
| 129 | IM | MB2 |
| 137 | FE | MB1 |
| 189 | IM | MB2 |
| 190 | UN | SO |
| 198 | FE | PO |
| 200 | IM | No |
Total Number=count(number)=9
Total MB1=count(MB1)=2
Total MB2=count(MB2) =2
Total SO=Count(SO)=1
I need to substract total Number -specific events.
I am looking for a way to get below output.
| Total Number | Total Number - MB1 | (Total Number-MB1) - MB2 | ((Total Number-MB1) - MB2)-SO |
| 9 | 9-2=7 | 7-2=5 | 5-1=4 |
Please let me know how can I get this.
Thank you!
Creating aggregated table referencing below link helped resolving my issue
https://community.fabric.microsoft.com/t5/Desktop/Create-new-table-using-another-table/m-p/3604179
4 Replies
Yes, I am looking this type of logic for multiple events to create burndown chart
Hi, ashuaswinireddy
Have you solved your problem? If so, mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Creating aggregated table referencing below link helped resolving my issue
https://community.fabric.microsoft.com/t5/Desktop/Create-new-table-using-another-table/m-p/3604179
