Forum

Hi Nadeem, Thanks for sharing your file. Before you Pivot the data, add an Index column (starting at zero or 1, it doesn't matter). Then Pivot the ...

Hi Melissa, This can be caused by various things. Did you check that the table in each file has the exact same name? e.g. Table1 Mynda

Hi Aye, I'm not aware of a way you can do that, sorry. Maybe create two matrix tables, one with actuals, one with a single budget column. Then alig...

Hi Alan, Replace the formula in E16 with this: =SUMPRODUCT(COUNTIF(B16:B60,"*"&B16&"*")) The problem you had is FIND can't take an ar...

Hi Junko, I don't know either, sorry. Mynda

Hi Maja, Can you please check your data as it's full of duplicates. e.g. ID 100260 is in there 3 times for January. I can't get the PivotTable to r...

Hi Junko, Once you have 2018 in your file I suspect it is stored in the Power Pivot Cache somewhere and you can't change that. Mynda

Hi Deborah, Both. The idea of ALLEXCEPT is that it allows your model to grow without you having to maintain filters for new columns/fields added. I...

Hi Aye, You can use a modified 'Expand Rows' technique from session 7.08. See file attached. Mynda

Hi Sal, Please see attached. Note: I had to recreate your file so the figures are random and won't match yours, but you should still get the ideal....

Hi Vinodh, I guarantee if Power Pivot says there are duplicates, then there will be duplicates. You can't have two dimension tables for the Ite...

Hi Maja, Thanks for the screenshots, however I can't tell from them what the issue is. Are you able to share a mockup Excel file with some sample d...

Hi Junko, I can't tell what the problem is without knowing what error you're getting. I don't have access to your source files so the error I get w...

Hi Maja, If you're looking at the measure at the month level of detail in the PivotTable then you don't need the MinDate and MaxDate criteria becau...

Nice formula, Velouria!