Forum Discussion
vanessafvg
Community Champion
Community ChampionDAX equivalent of SQL Coalesce
does any one know if a function like this exists?
There's no such a equivalent function, however you could replicate it with SWITCH.
value = SWITCH( FALSE(), ISBLANK([value1]),[value1] ,ISBLANK([value2]),[value2] ,ISBLANK([value3]),[value3] )
Eric_Zhang
Microsoft Employee
Microsoft EmployeeThere's no such a equivalent function, however you could replicate it with SWITCH.
value = SWITCH( FALSE(), ISBLANK([value1]),[value1] ,ISBLANK([value2]),[value2] ,ISBLANK([value3]),[value3] )
efilipeHelper IV
Now it's possible. Do a quick serch in Google.
Edgard