Power Query (Get & Transform) – Part 2

In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data into Excel.

In this 6 minute video I follow on from that introduction and add an extra transformation step to get the dates I need.

Once I have the required data I convert it into a Pivot Table and Pivot chart and add some user-friendly Slicer filters.

 

If you missed part 1 take a look here…

https://accessanalytic.com.au/faq-items/power-query-get-transform-introduction-part-1

 

Supporting Files

Download Source CSV Files if you’d like to try this out yourself

 

Information

For more information  on Power Query and Power BI then please read this article

 

Training

For training courses in Power Query and Power BI please click here