I wrote a blog post on PowerPivotPro.com last week on how to create a standard Power Pivot calendar using Power Query – from scratch. I was doing some research this morning on how I could extend this concept to create a 4/4/5 Calendar (which is often used in the Retail Industry). I was looking at this on-line reference documentation to find a function for a particular problem, and it was really hard to find what I was looking for. There is no index at the top of the page, just a very long page of sections and formulae.
Then I had a brilliant thought – I wonder if I could use Power Query to download the Power Query documentation? I tried it out, and the answer is a resounding yes. This is what I did.
I copied the link to the web page. This is the one I was using
I then opened a blank Excel workbook and went to the Power Query tab and inserted the above link in the box.
The Power Query Navigator returned a long list of formula categories, so I knew I was onto something.