Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.