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.
Hello experts,
I have a tough one for you:
I have a bunch of columns like this:
Qry1 Qry2 Qry3 Qry4 Qry5 Qry6 Qry7 Qry8 Qry9 Qry10
1 N N N N N N N N Y N
2 N N Y N N N N N N N
3 Y N N N N N N N N N
Notice the 'Y's?
Well I need to reduce this to one column using the headers where the value is 'Y'. the output should look like this:
MyNewColumn
1 Qry9
2 Qry3
3 Qry1
Basically use the column header where there is a 'Y'. I guess I need a calculation column of some sort but I haven't found anything on the net as to using headers as value.
Any help is appreciated.
Solved! Go to Solution.
Hi @Nicolas,
In the query editor do as follows:
1 - Select all your columns
2 - Unpivot columns
3 - FIlter Y values
Regards
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Nicolas,
In the query editor do as follows:
1 - Select all your columns
2 - Unpivot columns
3 - FIlter Y values
Regards
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin 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 |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |