Forum

Hi David, There's no built in way to do exactly what you want. Your options are to use Slicers with an Excel Table, or write some VBA that executes...

Can you upload a file with your data so I can see it in context?

Hi Steven, Incremental refresh is not available in Power Query for Excel yet. It's in development and has been released in 'Preview' in Power Query...

Hi Anne, No file attached. You need to click the yellow 'start upload' button after selecting your file. Cheers, Mynda

Hi Lea, It will be time well spent to read the tutorial because there are other nuances not covered in this answer: =SUMIFS(data[[sum]:[sum]],da...

Hi Tykru, In the Power Query editor window go to the File tab > Options & Settings > Data Source Settings > Edit Permissions > unde...

Hi Mardi, You're right, you can't create a Pivot Chart from multiple PivotTables, so you either have to fix your source data so it works the way yo...

Thanks, Matthew. It's good to know I could help, but you're the one doing the really hard work of learning and implementing. Ironically we're in th...

Glad you solved it. As painful as it is to start from scratch, often it's the quickest and best solution, so well done 🙂

Hi Lea, There's no file attached. You need to press the yellow 'start upload' button to complete the file upload. That said, this post explains ...

Glad you figured it out yourself. It's a great way to learn 🙂

Hi Anne, I think this part of the formula (ParameterEarnedDate-[StartDate]) is the problem because it's a date/duration and you're trying to add it...

Hi Vic, I tested Sunny's File; Vic-hid-sheets.xlsm in Excel Office 365 and can't reproduce the problems shown in your video. I wonder if it's some ...

Hi Sandra, It sounds like the problem is that the source data is not in the correct date format to allow the PivotTable to group the dates. This is...

No, sorry. I don't cover VBA.