DAX: COALESCE - New for March 2020

Returns the first expression that does not evaluate to BLANK. If all expressions evaluate to BLANK, BLANK is returned.

https://docs.microsoft.com/en-us/dax/coalesce-function-dax

@marcster_uk,

Thanks for highlighting this. I think it’s a pretty useful function - nothing you can’t do through other means, but an efficient way of handling a common set of situations. A perfect situation for the use of this function actually came up in a thread last night:

  • Brian