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:
Miguel Félix Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Check out my blog: Power BI em Português