How To Dynamically Work With Mixed Fixed Column Width In Power BI

In this video, Melissa is joined by Mudassir and Jarrett as we experiment on a new tutorial format for a more collaborative experience. The Enterprise DNA experts will demonstrate how they resolve and dynamically work with a mixed column width file. ***** Video Details ***** 00:00 Introduction 00:35 The problem 03:43 Checking a fixed length file 06:12 What index to use 06:50 Header position 08:45 Transforming dat to a list 08:54 Loading into memory 10:37 Determining where the header starts 18:48 Fill down 20:26 Splitting columns 26:04 Trimming text strings 27:55 Removing excess values 29:39 Self merge tables ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - FREE COURSE - Ultimate Beginners Guide To DAX - FREE - Power BI Resources - FREE - 60 Page DAX Reference Guide Download - https://enterprise