Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
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 🙂
You are great, thank you. This is extremely helpful.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
18 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
16 | |
15 | |
13 | |
12 | |
11 |