Ready to curb your Power BI skills? Find out more here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

Print

Extract in Power Query (LEN, LEFT, RIGHT in Excel)

In today’s video we will go through the equivalents of LEN, LEFT; RIGHT in Power Query. You can create very complex transformations using the interface in Power Query.

Table of contents:

02:46 -Text Before delimiter
03:37 – Count length of text
04:03 – Extract First character
04:11 – Extract Last Character
04:16 – Extract Between Characters
04:46 – Extract from Range

Watch the tutorial:

Extract in Power Query (LEN, LEFT, RIGHT in excel) - #6 (M)agic (M)ondays
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents