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.
comment: with Column X as placeholder
if ColumnA <> "" then
ColumnX = ColumnA
if ColumnB <> "" then
ColumnX = ColumnB
if ColumnC <> "" then
ColumnX = ColumnC
Go to Solution.
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)
View solution in original post
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.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.