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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

How would this Excel formula be in Power Bi

I would greatly appreciate your help.
I need to create a table with the first 9 characters of each data in this table.

Screenshot (89).png

I already searched but I have not understood how to adapt it to my need
I also tried LEFT (<text>, <num_chars>) and I get an error.
thanks.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@amitchandak 

try with
= Text.Start ([UANO], 9) and what I needed came out.
I appreciate your time taken to help me, greetings.

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

The left should give you the required result. Can you share the error?

 

like :  LEFT (UANO, 9)

 

If possible please share a sample pbix file after removing sensitive information.
Thanks

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

 

Screenshot (92).png

 

This is the error.

Screenshot (91).png

Anonymous
Not applicable

@amitchandak 

try with
= Text.Start ([UANO], 9) and what I needed came out.
I appreciate your time taken to help me, greetings.

Are you working in Edit query mode? In that, you need to use the M language. Left is Dax function.

In Model view (Not in edit query mode), create a new column, it should work

 

Edited - Seems like got the solutions .

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!