Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |