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

Question

Hi,&nbsp;How do I use M to check for a value from multiple columns, in my case 3.&nbsp;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.&nbsp;Something like&nbsp;comment: with&nbsp;&nbsp;Column X as placeholder&nbsp;if ColumnA &lt;&gt; "" then&nbsp; &nbsp; ColumnX = ColumnAelse&nbsp; &nbsp; &nbsp; if ColumnB &lt;&gt; "" then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ColumnX = ColumnB&nbsp; &nbsp; &nbsp; &nbsp;else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ColumnC &lt;&gt; "" then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ColumnX = ColumnC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end if&nbsp; &nbsp; &nbsp; &nbsp; end ifend if

anonymous · Accepted Answer

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]&lt;&gt; null then [ColumnA] else if [ColumnB]&lt;&gt; null then [ColumnB] else if [ColumnC] &lt;&gt; null then [ColumnC] else null)
&nbsp;
&nbsp;
Regards,Xiaoxin Sheng

Forum Discussion

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

2 Replies

Related content

Date Different return wrong value

Power Query or Calculated columns

Get first date a value from another column exists

Copy only Date Values into New Column

Find Most Recent Date Relative to another Date Column in Power Query