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,
Im trying to change around a table in query editor in a specific way and cant quite get it right, hopefully someone can point me in the right direction.
So my table is all text and formatted in two columns like this:
Category Entry
Cat1 entry1
Cat1 entry2
Cat1 entry3
Cat2 entry1
Cat2 entry2
Cat3 entry1
And essentially I want to end up with a table like this where categories become the column names:
Cat1 Cat2 Cat3
entry1 entry1 entry1
entry2 entry2 -----
entry3 ------ -----
the catch is that the categories will vary in name and quantity so I cant reference a column name in the M code and I need the entries in the column to just contain the unique values and then Nulls or some other placeholders.
Thanks in advance!
Solved! Go to Solution.
@murrayb8 solution is attached, check it out.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@murrayb8 solution is attached, check it out.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Ah! I was super close to this but just didnt use the rank column, awesome and thank you kindly!
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |