The Manual Method Using the Power Query Interface Remember - never pre-transform your data before you transform it in Power Query. You’ll just have to do it manually again the next time you get a file from someone. We do not want to consolidate the headers in Excel. For simplicity’s sake, I’ll use Power Query in Excel for this since my data is in Excel already, but the same logic would hold if you were importing the data into Power Bi. The second way will be a custom function that will do all of the work for you. The first way will be to do it manually mostly using the Power Query user interface.
Getting this info into Power Query can sometimes be a challenge.
0 kommentar(er)
