Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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êsUser | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |