Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table that has 4 yes/no fields. I would like to combine these fields into one field and if they have Yes in the cell then I would like for the value to be the field name that is being merged. For example if International (Y/N) is showing Y on a row then I would like for the new merged column to say International (Y/N) instead of Y. See image below.
Solved! Go to Solution.
In Power Query go to the Add Column section and choose Conditional Column. You can add clauses looking at the different columns and set the value accordingly
In Power Query go to the Add Column section and choose Conditional Column. You can add clauses looking at the different columns and set the value accordingly
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |