IFNULL equivalent

nagashankarp · May 27, 2025, 1:44pm

I have a requirement to display a field (revised target date) value and in case it is null, need to display a different field (planned target date)

in tableau, this is acheivable by using IFNULL

IFNULL([Field],[FieldOrValueSameDataType])

is there a similar easy formula in eazyBI

nauris.malitis · May 27, 2025, 1:59pm

Welcome to the Community!

There is indeed such a function in MDX, it’s called CoalesceEmpty.
You can check it out here in our documentation: CoalesceEmpty

Best regards,
Nauris