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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
vitexo87
Post Prodigy
Post Prodigy

How to limit the amount of characters in a field of a table?

I have a field in a certain table that most records have more than 20 characters each, and I need to use only the first 15, how can I do?

 

Obs: I tried to use the strokes to divide the column by characters but some characters disappeared with this as you can see in the pictures

 

Untitled.pngUntitled1.png

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@vitexo87

 

Hi,

 

 

You can Use Extract--First Characters--and Enter 15.

 

You can find this action in Transform or Add Column

 

Let me know if works.

 

Regards

 

 




Lima - Peru

View solution in original post

3 REPLIES 3
v-sihou-msft
Employee
Employee

@vitexo87

 

To get fixed length of text from a text column, you can use Extract as @Vvelarde suggested, this will add a Power Query step in Query Editor like:

 

#"Inserted First Characters" = Table.AddColumn(#"Changed Type", "First Characters", each Text.Start(Text.From([Project Name], "en-US"), 15), type text)

Or you can add a calculated column and use DAX to achieve your goal.

 

 

First 15 = LEFT(Table[Column],15)

Regards,

 

Vvelarde
Community Champion
Community Champion

@vitexo87

 

Hi,

 

 

You can Use Extract--First Characters--and Enter 15.

 

You can find this action in Transform or Add Column

 

Let me know if works.

 

Regards

 

 




Lima - Peru
Anonymous
Not applicable

hi, for my problem I have a colum with variety character length. Some are 13, letters, some are 10 and such. So I only want to extract the first 8 characters from a 13 letters character. However on the add custom column it says it cannout found the LEN or len, but no syntax error whatsoever. How do I solved this?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.