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.

@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