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...
Watch video Extract Records From Delimited Data in Power BI online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 25 June 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 5,142 times and liked it 116 visitors.
