Formula errors

Hi,

Thanks for lbendlin's concern about the problem and i want to offer some more infotmation for user to refer to.

hello sahmed1048576 , you can try the following dax in a calculated column.

Column =
IF (
    LEFT ( [X2], 2 ) IN { "101", "102", "103", "104", "105" },
    "Chill Pallet",
    IF (
        LEFT ( [X2], 3 ) = "418",
        "Ambient Shelving",
        IF (
            INT ( LEFT ( [X2], 3 ) ) >= 401
                && INT ( LEFT ( [X2], 3 ) ) <= 449,
            "Ambient Pallet",
            IF (
                LEFT ( [X2], 1 ) = "2",
                IF (
                    LEFT ( [X2], 3 ) = "205",
                    IF (
                        INT ( MID ( [X2], 4, 3 ) ) >= 70
                            && INT ( MID ( [X2], 4, 3 ) ) <= 148
                            && MOD ( INT ( MID ( [X2], 4, 3 ) ), 2 ) = 0
                            && VALUE ( MID ( X2, 7, 2 ) ) IN { 10, 20, 30, 40, 50 },
                        "CD Shelving",
                        "CD Pallet"
                    ),
                    "CD Pallet"
                ),
                "Other"
            )
        )
    )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.