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
