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.
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
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |