Check 4 columns > Return the one that is not blank.

[Anonymous]

Hi guys,

I swear i have tried everything all searched all the forumns but couldn´t find a solution.

Basically, need to check 4 columns and there is a standard:

>> always 3 blanks and 1 filled (in different orders)

Need to return the filled value in another column.

Many thanks for helping!

Cheers.

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

In power  query, you could create a conditional column as below:

Home->Add column->Conditional column

Regards,

Lin

[amitchandak]

@Anonymous 

You can use IF/Switch true and isblank , if you are a version before March 2020

if(isblank([Col]),if(isblank[col2]),[col3],[col2]),[col1])

From march you have coalesce

https://docs.microsoft.com/en-us/dax/coalesce-function-dax

coalesce([col1],[col2],[col3])