Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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!
Wow, that is exactly what I need. Just I don't know how to add M Code to my file. I'm assuming it's in the Power Query.
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!
I thought so but hadn't tried it yet. Woot it worked! I would buy you the beverage of your choice if I could.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |