Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've created a table by summarising my main table using the formula below.
Hi @bo_afk
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!
Refer : https://radacad.com/pivot-and-unpivot-with-power-bi
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi @bo_afk ,
Rather then creating summarised table using DAX, you can do same in Edit Query:
1. Create a summarised table from main table using GROUP BY in "Edit Query"
2. Transpose this summarised table as required.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
@Pragati11 thanks for your response. Seems like it could work in my case. Is the new summarised table still linked to the original? If I filter from the original table, do the values change accordingly in the summarised table?
Hi @bo_afk ,
Just create relationship between your summarised table ans original table on a key column. Once that is done, it will get filtered properly.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |