Coalesce
Scalar
Coalesce(a, b, …)
SQL COALESCE: returns the first non-NULL argument. The standard tool for turning blank aggregates into zeros (Coalesce([Revenue], 0)) and for giving Switch a blank-safe scrutinee.
When to use it
Section titled “When to use it”- Showing 0 instead of blank on cards and tables for groups with no rows.
- Blank-safe arithmetic:
Coalesce([Returns], 0)before subtracting it from[Revenue](blank would blank the whole result).
Example
Section titled “Example”RevenueOrZero := Coalesce([Revenue], 0)