Skip to main content

    Power BI

    Needs Votes

    Add Switch/Case Statement to M

    Vote (22) Share
    Colin Banfield's profile image

    Colin Banfield on 27 Aug 2015 01:25:45

    I am amazed that M has never implemented some form of Switch/Case statement, even though such a statement is at least as important in M as it is in Power Pivot. In many scenarios, Switch/Case would be a better option than a bunch of nested "if" statements.

    Comments (1)
    Colin Banfield's profile image Profile Picture

    Aaron Wright on 24 Sep 2022 16:13:58

    RE: Add Switch/Case Statement to M

    As a developer who uses SWITCH extensively in DAX, it's frustrating to have to create nested IF statements in M. Core functions like this should be available throughout the platform.