How can i extract the last numbers (32) of characters from a column and keeping query folding

[daanp]

Hello all,

I'm trying to extract the last 32 chars from a column. When i do this, query folding is no longer possible.

How can i extract the last 32 chars AND keep query folding? What M code should i use?

Best regards,

Daan

[Abduvali]

Hi @daanp,

Have you tried the following:

• Column 2 = LEFT(Sheet1[Item_name],2) or Column 2 = RIGHT(Sheet1[Item_name],2) 
• In your case number would be 32

Regards

Abduvali

[daanp]

Right or Left isn't a valid M statement. 

[v-shex-msft · Accepted solution]

Hi @daanp,

It will be help if you share sample file/data for troubleshooting and analysis.

BTW, if you want to get last 32 characters for column, you can add a custom column with 'Text.End' function.

 #"Added Custom" = Table.AddColumn(#"PreviousSteps", "Last32", each Text.End([ColumnName],32))

Regarads,
Xiaoxin sheng