Skip to main content

Power BI

Needs Votes

Add function IFBLANK(Value, Alternate)

Vote (12) Share
Jon's profile image

Jon on 28 Oct 2017 05:40:43

Add function IFBLANK(Value, Alternate) similar to IFERROR () .

This would prevent having to constantly write:
IF(ISBLANK(Value), Alternate, Value).

Comments (3)
Jon's profile image Profile Picture

Petr on 05 Jul 2020 23:39:00

RE: Add function IFBLANK(Value, Alternate)

The IF(ISBLANK(Value), Alternate, Value) syntax is awful and not very readable. A variable can be used to prevent repeating long expression, but I completely agree IFBLANK function should be added to the language.

Jon's profile image Profile Picture

Gilles on 05 Jul 2020 23:26:53

RE: Add function IFBLANK(Value, Alternate)

I posted recently a very similar idea :
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34650361-nz-for-power-bi

Jon's profile image Profile Picture

Daniel Yuncken on 05 Jul 2020 23:07:13

RE: Add function IFBLANK(Value, Alternate)

Further to Jonathan's comment... If the 'value' is a resource hungry calculated measure, avoiding calculating it twice would improve performance