Power Query - Add Report Context fields as Columns🩺📖

In this Video i show you how to add Report Context fields as columns in a dataset do some excellent transformations and unpivot the dataset and put it all in a function to run on many similar datasets. #dataanalytics #data #datatransformation #powerbi #powerquery #powerbidesktop #excel #investment Solution File with Mquery https://github.com/jbotes/powerbiTutorials/blob/main/PQ_ReportheaderIntoReportVideo.xlsx Source Files https://github.com/jbotes/powerbiTutorials/blob/main/PQ_SourceData_Portfolios.xlsx Noteworthy techniques - Custom Function Text.AfterDelimiter https://powerquery.how/text-afterdelimiter/ Table.Skip https://powerquery.how/table-skip/ Table.PromoteHeaders https://powerquery.how/table-promoteheaders/ Table.UnpivotOtherColumns https://powerquery.how/table-unpivotothercolumns/ Table.CombineColumns https://powerquery.how/table-combinecolumns/ Table.TransformColumns https://powerquery.how/table-transformcolumns/ Table.TransformColumnTypes https://powerquery.how/table-transformcolumntypes/ Table.SelectRows https://powerquery.how/table-selectrows/ Table.Combine https://powerquery.how/table-combine/