Power Query Left Function

Power Query Left Function using Text.Start

ByPower BI

The power query left function can be replicated using Text.Start function. In most languages, we use the left function to extract the desired number of characters from the left side of the given string.

The syntax of the Text.Start function in the Power query is straightforward.

Text.Start(Given string, number of characters that needs to extract=

It takes two parameters.

  • The first parameter is the given string.
  • The second parameter is the number of characters we want to extract from the left side.

Power Query left function example.

Let’s see, we have a table that contains a list of months, and we want to extract the first three characters.

Months dataset

You need to follow the process step by step.

  • Go to the Power query editor. 
  • Select add column
  • Select custom column
  • Write the name of the column. You can write any suitable name.
  • Write the following formula.
Text.Start([Months],3)
Power Query Left Function

The above procedure will create a new column, “Short Month,” containing the first three months’ characters, as you can see below.

Text.Start output

If text.start power query

If condition with text.start power query function is very handy in a lot of scenarios.

Let’s try to write a formula to obtain all those months that begin with the letter “J”; otherwise, return null.

if Text.Start([Months],1) = "J" then [Months] else null
if text.start power query

You will see the below results.

In this article, you have seen how to implement the power query left function with the help of Text.start function.

To learn more, please visit Learn DAX

Similar Posts

Splitting Text Strings with Power BI Text.SplitAny Function

Splitting Text Strings with Power BI Text.SplitAny Function

ByPower BI

Text.SplitAny is a Power Query function that allows you to split a text string into multiple parts based on one or more delimiters. This is useful when you have a text string that contains multiple values, such as a comma-separated list, and you need to extract each value individually. Syntax The Text.SplitAny function takes three…

What is Text.BetweenDelimiters and how do we use it?

What is Text.BetweenDelimiters and how do we use it?

ByPower BI

Text.BetweenDelimiters is a Power Query function in Power BI that returns the portion of text between the specified startDelimiter and endDelimiter. An optional numeric startIndex indicates which occurrence of the startDelimiter should be considered. An optional list startIndex indicates which occurrence of the startDelimiter should be considered, as well as whether indexing should be done from the start or end of the input. The endIndex is similar, except that indexing…