Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
72 | |
49 |
User | Count |
---|---|
143 | |
131 | |
109 | |
64 | |
55 |