Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |