Thank you so much for your lessons. You are very clear and concise in your teaching methods, even the things I thought I've taught myself I get so much more out than I knew possible! I am plugging my way through the Power Query course and am on lesson 4.13 and was playing around with some of the other options. I was wondering how I would change the layout of the dates, eg. putting the start of the quarter but what if I want that displayed with just the month and day? Would that need to be formatted once it is loaded onto the worksheet or is there a way to do that in query?
Hi Jessica,
Great to hear you're getting a lot out of the courses
You can either format the start of quarter date in Excel to only display the month and day, this would retain the underlying date serial number that can be used in other formulas and be grouped in a PivotTable.
Alternatively, you can change the star of quarter date to text in Power Query using the Date.ToText function. If you use this then the values will no longer be recognised as dates.
Hope that helps.
Mynda
