Forum

Hi Subash, I agree with Anders. PivotTables is definitely the way to go as they're much more robust. Formula solutions like this will inevitably br...

Hi Minki, Welcome to our forum! The Slicer doesn't respect the Top n filter for the purpose of hiding items with no data, sorry. I wonder if you...

Hi Erik, In Power Pivot you need to set the 'Sort By Column' for the weekday as the 'Number' column. This tells Excel to sort the weekday text by t...

No worries. Start a new thread when you come back.

Hi Eric, Welcome to our forum! Thanks for sharing your file. This makes it much easier to diagnose. Your OFFSET formula is counting cells J9:J10...

Hi Erik, Thanks so much for sharing the file. It's much clearer now. The key information missing is that you're creating a Power Pivot PivotTable. ...

Hi Pieter, No apology necessary, I am just trying to illustrate that we're taking two steps forward and one step back (sometimes two) with each exc...

Hi Linda, I suggest you download their sample file and inspect it and compare it to yours to identify differences in the way you have structured yo...

Hi Richard, When I said filter out the months you don't need, I should have used the word 'dates'. i.e. make sure your dates in your PivotTable are...

Hi Pieter, While it may work, this is fundamentally the wrong approach. Fact tables have values, dim tables typically don't. You're forcing the All...

Hi Linda, It's not the SalesOfCustomer that's wrong. I suspect it's because in the COUNTROWS formula you've added the 'DISTINCT' function, whereas ...

Hi Amien, You can try this formula where your delivery dates are in the 'Date' column of an Excel Table: =IF([@Date]<TODAY(),"Overdue in ","F...

Hi Valerie, Welcome to our forum! In terms of your first task, it sounds like you have the task in hand and just need help with the reporting side....

Hi Pieter, You've got yourself confused. The dimension tables filter the fact tables, therefore the relationship was correct because the Alloc dim ...

Hi Erik, It shouldn't matter what the sort order is in Power Query as this is just the tool to get the data, it's once it lands in the PivotTable t...