In an earlier part of our series looking at new tools for working with accounting data in Excel 2010 and 2013, we looked at some of the DAX functions available when using the Power Pivot add-in that relate to dates and time.
We also mentioned the need to work with a special table containing all the possible dates. This time, we'll consider some...
About Simon Hurst
Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.