Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Simon_Br
Helper I
Helper I

Text.End Variable Value

Hello Comunity,

 

Actaul i have the challange, an value to split whit a dynamic value in the M-Code in Power Query.

 

Per Example:

 

TextLength NumberSolution

America30

230
Australia3003300
China48500548500
Africa444
Europe154879371548793

 

How can i do that?

 

Simon

 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi Simon,

 

This should work fine in a new custom column:

 

Text.End([Text], [Length Number])

 

 

BA_Pete_0-1694698519192.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

3 REPLIES 3
BA_Pete
Super User
Super User

Hi Simon,

 

This should work fine in a new custom column:

 

Text.End([Text], [Length Number])

 

 

BA_Pete_0-1694698519192.png

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Simon_Br
Helper I
Helper I

Thank for the answer.

And whit the length? ... each Text.End(_, value(length number),... 

 

 

wdx223_Daniel
Super User
Super User

Splitter.SplitTextByCharacterTransition(each not List.Contains({"0".."9"},_),{"0".."9"})([Text])

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors