Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a table with multiple columns. I need to produce Excel like format in Powerbi with SUBGROUP TOTLS AND GRAND TOTAL. It's not matrix report as all these are columns. Order of c4-SUM-1, and C5-SUM-2 is important. Everything should look like similar.
Thanks
Hi @topkapi,
How do you group the data and the c4-SUM-1, and C5-SUM-2 are the calculated columns you want to created in Power BI ?
It seems that you want to create a table with the columns like the output you uploaded?
It will be better for understanding if you could replace the XX to numbers.
Best Regards,
Cherry
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |