Column Transformation Coding Help!

[sanantonio]

Hi All,

Not particularly experienced with Power BI. Any help would be greatly appreciated.

Our business has always worked with 6 digit basic "article" numbers, for example 123456; which are often displayed in their "long" form when extracting data from our system. EG: 123456001. For data analysis and reporting etc. any export that produces this long number is always shortened to it's 6 digit. In excel we'd use

=Left(A1,6)

for example.

Issue has arisen that some Product Groups have used up their assigned 6 digits so will begin using 7 digit numbers. In excel this isn't an issue for me, we've been using:

=LEFT(B1,LEN(B1)-3)

. However I'm now trying to reverse engineer some Power BI's that were built by someone no longer with the business.

What is the Power BI speak equivalent of

=LEFT(B1,LEN(B1)-3)

that I can insert into the query to replace the existing code?

 

[Candyman8019]

in your power query can't you just replace the '6' with a '7'?

 

[JGordon11]

Text.Start(_,Text.Length(_)-3)

 

[sanantonio]

in your power query can't you just replace the '6' with a '7'?

Unfortunately not as some articles will remain 6 and some 7.

Text.Start(_,Text.Length(_)-3)

Awesome avatar btw! Great thanks! I'll give this a go and report back

 

[sanantonio]

Seems to be working. Thank you very much