Learn How To Dynamically Merge Different Columns In Power BI
For today’s tutorial, I’m going to demonstrate how you can dynamically merge columns using a low code method with the Power Query Table.CombineColumns function. Learn how you can make optimal use of the user interface to minimize the need for coding. For this example, I’ll be working with raw data exports that causes data to spill into an unknown number of adjacent columns.
Melissa
**** Video Details ****
00:00 Introduction
01:00 M code generated
02:43 Merge a changing number of columns
04:15 Replace trim function with own logic
06:27 Filter description
06:48 Drill down
**** 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...
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial
Watch video Learn How To Dynamically Merge Different Columns In Power BI online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 23 April 2021. 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 46,237 times and liked it 417 visitors.
