Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
This is my table Book1.xlsx
Value
ABC1234 |
BAC5678 |
123X756 |
222D897 |
ADC1234 |
ADX4325 |
But how can I show if there are three numbers before or after X or D then say Yes otherwise No.
Value Comment
ABC1234 | No |
BAC5678 | No |
123X756 | Yes |
222D897 | Yes |
ADC1234 | No |
ADX4325 | No |
Solved! Go to Solution.
Hi @mouzzampk,
Result:
[ a = Text.SplitAny([Value], "XD"),
b = List.AnyTrue(List.Transform(a, (x)=> try Number.From(x) is number and Text.Length(x) = 3 otherwise false)),
c = if b = true then "Yes" else "No"
][c]
Hi @mouzzampk,
Result:
[ a = Text.SplitAny([Value], "XD"),
b = List.AnyTrue(List.Transform(a, (x)=> try Number.From(x) is number and Text.Length(x) = 3 otherwise false)),
c = if b = true then "Yes" else "No"
][c]
This is awesome, thank you. Some next level stuff 🙂