Text.BetweenDelimiters

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…

Table.FindText in power query

What is Table.FindText in Power Query and How Do We Use It?

ByPower BI

Table.FindText is a Power Query function in Power BI that returns the rows in a table that contain specific text. If the text is not found in the table, then an empty table is returned. Syntax Table.FindText has simple syntax and can be written as the below. Table.FindText(table as table, text as text) as table…

How table.replacevalue power query function works?

How table.replacevalue power query function works?

ByPower BI

Table.replacevalue power query function helps us to replace the old value with the new value of our choice. The syntax of Table.replacevalue function is It is a pretty useful function during the data cleaning process for any Power BI project. In this post, we will see different flavors of Table.replacevalue function in Power query. Are…