Text.length Archives

Text.Length Power Query Function

ByPower BI October 19, 2022April 11, 2024

The text.length power query function helps us count the number of characters in the given string. This article teaches how to implement the Text.length function. It comes under the category of Text functions of Power query. Syntax It takes one parameter as a string and returns its length. Text.length function is equivalent to the Len…

Power query

Text.Insert Power Query Function

ByPower BI October 14, 2022April 11, 2024

Text.insert power query function helps modify the given string. Sometimes, we need to add a wildcard character at the start, at the end, or at both ends to retrieve data from different sources. Syntax The syntax of Text.insert function is It takes three parameters. Text.insert Power query function example. Let’s make a scenario where we…