Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Thank you very much in advance for your help!!
My issue i that:
in column Level i have values like this:
Level
1.1.1.1.1.3.10
1.1.1.1.1.4
1.1.1.1.1.4.1
1.1.1.1.1.5
1.1.1.1.1.6
1.1.1.1.1.7
1.1.1.1.1.8
1.1.1.1.1.8.1
1.1.1.1.1.8.2
1.1.1.1.1.8.3
and i need to generate a new column without last number and comma:
Level
1.1.1.1.1.3
1.1.1.1.1
1.1.1.1.1.4
1.1.1.1.1
1.1.1.1.1
1.1.1.1.1
1.1.1.1.1
1.1.1.1.1.8
1.1.1.1.1.8
1.1.1.1.1.8
1.1.1.1.1.8
Solved! Go to Solution.
Hi,
Extract text before last comma
Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})
Stéphane
Hi,
Extract text before last comma
Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})
Stéphane
FANTASTC!!!!!Really Really thank you!
Use Text.BeforeDelimiter, like this
Table.AddColumn(PriorStepOrTableName, "NewColumnName", each Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd}))
--Nate
COULD YOU PLEASE HELP?? I tried many ways without results...