"Translate" from MS Excel "IF" & "AND" & "OR" for a calculated column

[qkrekaamkese]

 hope you can help me...

My data also consist of a column “Order No”, being defined as Text.

Normally such an order number starts with “010”, “020” etc., sometimes also with “SE*…” or “MI*…”

Now I do need a solution how to identify specific order numbers and return text “Sales Order Germany” as result.

In Excel I would have written as follows, but I do not get it translated into PBI language…

IF

'Table'[Order No] begins with “010”   OR

'Table'[Order No] begins with “SE*01”   OR
'Table'[Order No] begins with “MI*” AND ends with “*101”

THEN

[Anonymous · Accepted solution]

Hi @qkrekaamkese ,

You can create a calculated column as below, please find the details in the attachment.

Column = 
IF (
    LEFT ( 'Table'[Order No], 3 ) = "010"
        || LEFT ( 'Table'[Order No], 5 ) = "SE*01"
        || (
            LEFT ( 'Table'[Order No], 3 ) = "MI*"
                && RIGHT ( 'Table'[Order No], 4 ) = "*101"
        ),
    "Sales Order Germany"
)

Best Regards