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

qkrekaamkese — Tue, 05 Mar 2024 13:00:17 GMT

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…

'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

Re: "Translate" from MS Excel "IF" & "AND" & "OR" fo

Anonymous — Wed, 06 Mar 2024 02:20:53 GMT

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

topic Re: "Translate" from MS Excel "IF" & "AND" & "OR" fo in Developer

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

Re: "Translate" from MS Excel "IF" & "AND" & "OR" fo