The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video


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