Forum Discussion

Copper Contributor

Jun 16, 2022

IF statement based on multiple columns.

Vendor 1 Vendor 2 Vendor 3 Vendor Master ABC BCD CDE Hi everyone, I'm trying to put up a IF formula for the following scenario. But I'm facing diffic...

BI & Data Analysis

excel

Formulas and Functions

office 365

power bi

Lorenzo

Silver Contributor

Jun 17, 2022

Hi SatishBadiger

For PowerBI/Power Query, similar to SergeiBaklan with the "No vendor" exception:

= Table.AddColumn(PreviousStep, "Vendor Master", each
    try List.RemoveNulls(Record.ToList(_)){0} otherwise "No vendor"
)