Forum Discussion

Matt_Mohawk's avatar
Matt_Mohawk
Icon for Helper II rankHelper II
4 years ago
Solved

Multiple Yes/No Fields Into one Field

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 bein...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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