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 without registration, duration hours minute second in high quality. This video was added by user Enterprise DNA 23 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 46,237 once and liked it 417 people.