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.
Hi all,
Answer to this query is really important for me.
I have a table with certain variables and I want to create a pivot table on that similar to excel. And I want to save this data of pivot table as an another table in Power BI, so that I can join the table with my base table.
Cheers
Shruti
Solved! Go to Solution.
Hi @Anonymous,
Please share your file or a dummy sample. We need to do it with DAX or Power Query. So we can't talk about it without data.
It could be something like this:
Best Regards,
Dale
Hi @Anonymous,
Please share your file or a dummy sample. We need to do it with DAX or Power Query. So we can't talk about it without data.
It could be something like this:
Best Regards,
Dale
Hi @Anonymous,
Seems you have gotten the solution. The formula could be:
Table = SUMMARIZE('Table1', Table1[Col2], Table1[Col1], Table1[Col4], "Sum of Col3", sum(Table1[Col3]))
Best Regards,
Dale
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |