Skip to main content

    Power BI

    New

    Add function IFBLANK(Value, Alternate)

    Vote (11) 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

    6f4b6a90 b665-485e-a91b-d1b320d125ce 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

    ec1b1aab 8c96-4b76-9d7c-b8658b2245d8 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

    e0cf6a91 db15-4588-a8f4-080b9bbe9b9b 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