Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the Name column and would like to extract it as the Expecting Name (Result):
Name | Expecting Name |
AZER.SDD | AZER |
AZEDT.FV | AZEDT |
AZERZ.cFS | AZERZ |
VSFS.DFS | VSFS |
12.12.12 | 12.12.12 |
12.34 | 12.34 |
VSD.ZRE | VSD |
DFS.RF | DFS |
12.234 | 12.234 |
If name starts by 12 , Expecting Name = Name
IF name starts by letter, expecting name = text before the first delimiter
Thank you in advance for your help.
Tg
Solved! Go to Solution.
Hi @vnqt ,
Do the TextBeforeDelimiter option and then change the code to:
= Table.AddColumn(Source, "Text Before Delimiter", each if Text.Start([Name], 2) = "12" then [Name] else Text.BeforeDelimiter([Name], "."), type text)
Has you can see the part of the split is updated to an IF statement:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @vnqt ,
Do the TextBeforeDelimiter option and then change the code to:
= Table.AddColumn(Source, "Text Before Delimiter", each if Text.Start([Name], 2) = "12" then [Name] else Text.BeforeDelimiter([Name], "."), type text)
Has you can see the part of the split is updated to an IF statement:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you for your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |