Get startedGet started for free

Merge & extract length

Your manager has decided to implement a naming convention for reseller sales rep names so they are easily distinguishable from Adventure Works own sales reps.

Your manager has also informed you that there is a limitation in the CRM software we are using that truncates any names with more than 24 characters, so he has asked you to verify the length of the longest name in the reseller dataset.

If you lost any progress, load the workbook 3_2_merge_extract.pbix from the Exercises folder on the Desktop and open the Power Query editor.

This exercise is part of the course

Data Preparation in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise