Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago
Solved

Power Query: Check for a value(date) in three columns

Hi,   How do I use M to check for a value from multiple columns, in my case 3.   In my situation I am looking for a value in a specific order, say column 1 first, then column 2 and then 3. Whoeve...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi ovetteabejuela,


    You can add a custom column to use below formula to check different columns.

    AddColumn = Table.AddColumn(#"Promoted Headers", "ColumnX", each if [ColumnA]<> null then [ColumnA] else if [ColumnB]<> null then [ColumnB] else if [ColumnC] <> null then [ColumnC] else null)

     

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ovetteabejuela,


You can add a custom column to use below formula to check different columns.

AddColumn = Table.AddColumn(#"Promoted Headers", "ColumnX", each if [ColumnA]<> null then [ColumnA] else if [ColumnB]<> null then [ColumnB] else if [ColumnC] <> null then [ColumnC] else null)

 

 

Regards,
Xiaoxin Sheng

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Anonymous,

 

Thanks, you beat me to it.. I did see some resource over the internet as well and this is definitely it, I'll just have to apply it and see how it goes but I think this is it.

 

Thanks again.