a function to pick the next value if the first value is empty.

[bbotros77]

Hello 

I need to create a Syntax for a column to check the values (text format) in 4 columns and if the first is empty pick the second , if second is empty pick the value in the third and so forth ..if all are empty I can just have the word "Blank"

what functions should i use 

thanks

[amitchandak]

@bbotros77 , You can have measure like

calculate(firstnonblankvalue(Table[COlumn], Sum(Table[Value]) , filter(all(table), Table[Column] >= max(Table[COlumn]) ))

Value is column having blank values