OnThisDayInHistory

0


This video shows how you can spin and clean a ‘messy’ dataset that clearly has structure in addition to making use of parameterised filtering. The dataset in question shows a series of dates within history going back 2000 years so you may learn something along the way 🙂

All of this is available within excel so please dig in.

The source files are contained here :-
https://1drv.ms/f/s!AgiOPf26tnzf_QY3T2ME4xatr5YV

You can download power query (Excel 2013) here:

https://www.microsoft.com/en-us/download/details.aspx?id=39379

If you have Excel 2016 you should not need to do any downloads.

Please drop me feedback if you find this useful.

source TDG/Data Spinners

Subscribe to Rory’s channel

Choose your Reaction!
Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.