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