Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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êsCheck out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |