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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bolabuga
Helper V
Helper V

[Calculated column based on number of characteres]

Hello everyone,

 

Suposing i have a colum "a" with data in format:

 

abc
5000700150007001
880019001880019001

 

I want to create column b e c, i have 400.000 rows that varies in size, 8 or 9 characters. Is there a way to count the size to use the count in a "if" statment like --> IF( "8 CHARACTERS" ; LEFT(A;5);LEFT(A;6)). the "001" is not a problem since it will always be RIGHT(A;3).

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@bolabuga

 

hi, with LEN function

 

https://msdn.microsoft.com/en-us/library/ee634917.aspx

 

 




Lima - Peru

@Vvelarde

 

Thks, that solves the problem.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.