convert excel formula to DAX

Hi Marcox28 

Without a sample pbix, it is hard to come up with a correct formula. Assuming the formula is for a calculated column, here is my conversion to DAX:

FORMULA = 
SWITCH (
    TRUE (),
    CONTAINSSTRING ( 'Table'[Column S], "TEST" ), "N/A",
    NOT 'Table'[Column D]
        IN { "DELETE", "TRUE", "REJECTED" }
            && 'Table'[Column L] = "1 - TOP"
            && 'Table'[Column R]
                IN { "DRAFT", "TO APPROVE", "TO START" }
                    && 'Table'[Column AO] = 0
                    && 'Table'[Column BB] <= DATE ( 2022, 1, 1 ), "ON",
    "OFF"
)

Note: SWITCH function is kind of a shorthand for multiple IF statements.