Extract Records From Delimited Data in Power BI
In this video, we are going to extract records from merged delimited data inside multiple columns using the M Function.
Hope you enjoy this one!
Melissa
****Video Details****
1:17 use Text.Split
1:50 add Competitor column
3:00 use List.zip
4:20 add Competitor Amount column
6:04 expand to new rows
6:48 extract values from the list
7:25 split column by delimeter
8:02 clean up the values
****For more Unpivot Variation series, click the links below****
Turn Calendar Type Layout Into Tabular Format In Power BI - Query Editor Tutorial - • Turn Calendar Type Layout Into Tabula...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links ****
Change Date Formats Using The Power Query Editor - https://blog.enterprisedna.co/change-...
3 Ways To Combine Values Using DAX Inside Power BI - https://blog.enterprisedna.co/3-ways-...
Advanced Transformations in Power BI - https://blog.enterprisedna.co/advance...
**** Related Course Modules ****
Dashboarding & Data Visualization Intensive - https://portal.enterprisedna.co/p/das...
Time Intelligence Calculations - https://portal.enterprisedna.co/p/tim...
Power BI Super Users Workshop - https://portal.enterprisedna.co/p/pow...
**** Related Support Forum Posts ****
Extracting By Delimiter And Unpivot Issue - https://forum.enterprisedna.co/t/extr...
Breaking Down The Data From Rows To Columns - https://forum.enterprisedna.co/t/brea...
Retrieve Value From Middle Of String In Measure - https://forum.enterprisedna.co/t/retr...
For more delimiter support queries to review see here - https://forum.enterprisedna.co/search...
Смотрите видео Extract Records From Delimited Data in Power BI онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Enterprise DNA 25 Июнь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,142 раз и оно понравилось 116 людям.