COALESCE DAX Function (Logical)
source link: https://dax.guide/coalesce/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Returns the first argument that does not evaluate to a blank value. If all arguments evaluate to blank values, BLANK is returned.
Syntax
Parameter Attributes Description Value1
Any value or expression.
Value2 RepeatableAny value or expression.
Return values
The first Value argument that is not blank.
Related articles
Learn more about COALESCE in the following articles:
-
From SQL to DAX: Implementing NULLIF and COALESCE in DAX
This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. » Read more
-
COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose conditions, and yet obtain the same result. » Read more
Related functions
Other related functions are:
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK