Forum Discussion

bbotros77's avatar
bbotros77
Frequent Visitor
2 years ago

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

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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    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