Forum

Thanks for the link, Erik. I'll pass it on to Microsoft and let you know as soon as I hear back.

Hi Erik, I've escalated it with Microsoft. I'll let you know what they say. I have a feeling that post is incorrectly listing Excel 2013 and 2016 a...

Hi Declan, If all 3 tables only store the values at the first of each month, then it would be a smaller file if you created one table with the foll...

Hi Desiree, As I explained when you emailed me about this same question: "Excel functionality isn’t typically classified as ‘complex formulas’ o...

Thanks for clarifying, Leah. You can get the data direct from Google Drive with Power Query, as opposed to creating another Excel file for the purp...

Hi Steven, You can change the level of grouping of dates in the PivotTable, or remove them altogether, by right-clicking the date field in the Pivo...

Sorry, uploaded now!

Hi Salman, Where to place Table.Buffer. Mynda

Hi Maree, In session 6.08 of the Power Pivot course I explain the ideal structure for your data in Power Pivot. Your DB administrator is right, you...

Hi Salman, Thanks for clarifying. There are a couple of issues/questions: 1. You can't do this with a regular PivotTable. You'd need to write a ...

Hi Brendan, Please see file attached. You need to write explicit measures to calculate the total hours and available hours, which you can then use ...

Hi Leah, You haven't said whether your Pivot report is a regular PivotTable or Power Pivot and I don't know if these dates are grouped using the ri...

Hi Lea, What kind of 'drive' are you referring to/what is the location of this drive; OneDrive (cloud), your local PC, a server etc.? I'm not su...

Hi Erik, Can you please tell me the version number AND build number that you have installed now. And share the link to the Microsoft page where it ...

Hi Declan, It's great to hear you're making use of Power Pivot. Power Pivot course session 6.07 deals with this. You can keep your 3 fact tables...