I have an SQL query that returns two columns with multiple values and I need to format it into a key value from the first column with multiple columns made from the values in the second column. I've looked and tried various methods (including pivot/unpivot) in Excel, SQL and Power BI. I'm hoping someone here can point me in the right direction for one of those. Here is a sample of the data being returned:
What needs to happen is this:
There may be 1 WC or there may be up to 21 (I believe). The current report -done through another product - shows up to 5.
Check this out:
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Check this out:
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Once you are in Power Query, you can go to the advanced editor. That is where the code is pasted
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - August 2024
Check out the August 2024 Power BI update to learn about new features.
Fabric Community Update - August 2024
Find out what's new and trending in the Fabric Community.
