Forum Discussion

Matt_Mohawk's avatar
Matt_Mohawk
Helper 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...
  • johnt75's avatar
    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