Forum Discussion
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 ....
amitchandak
Super User
Super Userbbotros77 , 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