Forum

Hi Frans, Paul's question was regarding the use of INDIRECT to toggle through a series of images as per session 5.11 of the Dashboard course. He ju...

Hi Mike, That sounds strange...the Power Query not working, not the Microsoft help being incorrect! So, to be clear, if you select New Query >...

Hi Jon, See example attached. I've added two helper columns that calculate the contract total as at the end of month you choose (in cell D2) and th...

Thanks for sharing, Steve.

Hi Martin, You'd be best to do this in Excel or maybe Power Query. It isn't a job for Power Pivot. Mynda

Hi Martin, You can't work with 1m+ rows of data using 32-bit, it will always choke. You need 64-bit. It's the only way to work with this much data ...

Hi Martin, Is the source data in a Linked Excel Table or is it coming from an external source direct to Power Pivot? Also, are you running 64-bi...

Hi Paul, Can you please share a sample workbook so we can help you further. If you prefer to share your actual workbook offline then you can email ...

Hi Nick, I'd set up some separate charts for the user to view the specific year so you're not having to mess with averages. I would also only ever ...

Hi Lori, Were you hoping to analyse the data from these different workbooks in a single PivotTable or even a single chart? In other words, would yo...

Hi Diana, I don't think you need to fix anything. It can only do 'one' to the side which has unique values in the column. If there are duplicates t...

Great. I'll email you personally to get a bit more information. Cheers, Mynda

Hi MrAhmed, Thanks for sharing the file. I can see instantly that the formula is using double quotes that are not the correct format. If you look a...

Hi MrAhmed, Please upload your Excel file so we can see where the issue is. Thanks, Mynda

Here is Raths' file he sent via email.