Text.BeforeDelimiter

Text.beforedelimiter is a power query function that returns the substring before a specific delimiter. It helps us to clean the data before importing it into Power BI. Syntax Text.BeforeDelimiter takes three parameters. The first two parameters are compulsory, and the third parameter is optional. Example Let’s take the following example to extract the substring using…