Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Morning,
I need to create new rows with sub-total and named in PBi tables from capture 1 to capture 2, as depicted below:
I cannot use power query as when i press on modify table there is no table which can be modified, perhaps use of dax function can help.
Thank you for you suggestions.
Vicky
@Vicky2023 One way would be to create Groups and then use those groups in a matrix ad-hoc hierarchy along with your original categories. The other way would be a disconnected table and a measure.
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |