Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
Hi @daanp,
Have you tried the following:
Regards
Abduvali
Right or Left isn't a valid M statement.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |