Extract only letters from a string of mixed characters (Part of Preppin' Data challenge week 2)

preview_player
Показать описание
Extracting letters from a string of mixed characters can easily be done with the Text.Select function in Power Query. Find out how to apply it.
You'll also learn how to quickly apply aggregations on groups.

#PowerBI #PowerQuery #PreppinData
Рекомендации по теме
Комментарии
Автор

It is a helpful technique to allow the UI to write the code for a built-in function with similar syntax and then edit the code to do what you want. Thank you.

retamapark
Автор

I have a question . Why 'Average value sold per Bike, Brand' column has difference in actual and expected output . Please compare between challange output and our Power bi calculated output.

omnnara