Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
VAR result =
IF (
ISBLANK ( [col1] ),
BLANK (),
IF (
ISBLANK ( [col2] ),
BLANK (),
( DIVIDE ( [col1], [col2] ) - 1 )
)
)
RETURN
result
Does anyone know how to convert code using Coalesce ?
Thanks for your support.
Solved! Go to Solution.
Here's an example of how the code can be converted using Coalesce:
VAR result = DIVIDE ( COALESCE ( [col1], BLANK() ), COALESCE ( [col2], BLANK() ) ) - 1 RETURN result
Coalesce is a function that returns the first non-blank value in a list of expressions. In this case, it's being used to replace the ISBLANK function. The result will be the same as the original code but using a different function.
Here's an example of how the code can be converted using Coalesce:
VAR result = DIVIDE ( COALESCE ( [col1], BLANK() ), COALESCE ( [col2], BLANK() ) ) - 1 RETURN result
Coalesce is a function that returns the first non-blank value in a list of expressions. In this case, it's being used to replace the ISBLANK function. The result will be the same as the original code but using a different function.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
9 |