Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
12 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
14 | |
4 | |
3 | |
3 | |
2 |