cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Impactful Individual
Impactful Individual

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. Whoever is non-empty, grab the value.

 

Something like

 

comment: with  Column X as placeholder

 

if ColumnA <> "" then

    ColumnX = ColumnA

else

      if ColumnB <> "" then

           ColumnX = ColumnB

       else

              if ColumnC <> "" then

                    ColumnX = ColumnC

              end if

        end if

end if

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

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

@v-shex-msft,

 

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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors