Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Can I have help on this one. So I'm try to extract certain lenght text string based on the length of the text string in column and minus certain lengh. Example like this:
= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length([Description1])), type text}})
But I'm getting error like this:
Can anyone shed any light on this please. Thanks in advance.
Solved! Go to Solution.
= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length(_)), type text}})
= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length(_)), type text}})
Interestingly, use "_" to refre to the column name, is that documented somewhere?
Great! That works, thanks so much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |