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/powerbiTuto...

Source Files
https://github.com/jbotes/powerbiTuto...

Noteworthy techniques
Custom Function

Text.AfterDelimiter
https://powerquery.how/text-afterdeli...

Table.Skip
https://powerquery.how/table-skip/

Table.PromoteHeaders
https://powerquery.how/table-promoteh...

Table.UnpivotOtherColumns
https://powerquery.how/table-unpivoto...

Table.CombineColumns
https://powerquery.how/table-combinec...

Table.TransformColumns
https://powerquery.how/table-transfor...

Table.TransformColumnTypes
https://powerquery.how/table-transfor...

Table.SelectRows
https://powerquery.how/table-selectrows/

Table.Combine
https://powerquery.how/table-combine/