Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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