Forum

Thanks, Julian. That's very kind of you. We sincerely appreciate it. Mynda

Hi Bruce, In the attached file which you sent me via email I’ve used a custom column with an ‘if’ statement to bring the Office name and details in...

Hi Anton, You can duplicate the query and use the Group tool (lesson 4.16) to count the pass results and then use Merge to bring the count back int...

Hi Mitul, I too am confused at your question when in sheet 5 you have already created a PivotTable with the desired result. Of course you won't ...

Hi Ashwini, This requires VBA/Macro to detect changes in cells. Please post your question in the VBA forum as this is outside the scope of the Dash...

Hi Wendy, I'm not sure what the problem is exactly, but I wonder if you're trying to use Power BI Desktop to connect to OneDrive. That's not what I...

That's what I'm saying...I don't know a secret path. I presume it's by design that you can't easily delete them. I imagine you'd have to unzip the .xl...

Hi Trish, Despite being around for years now, Power Query and Power Pivot are relatively new and many Excel users have never heard of them, or if t...

Most likely, Matthias, but I'd say it's by design because it's not affecting how Excel runs. It's only apparent to you because you're using the PP Uti...

This sounds like a PP Utility issue, not a Power Query issue. You need to go back to the provider of PP Utility with your request as there is nothing ...

So when you say the measure is listed after being removed from the PivotTable, do you mean it is still listed in the PivotTable field list, or do you ...

Hi Dillnesaw, What do you mean by "i want it to assign the sku description for each duplicate item ID evenly"? I don't see any pattern to the SKU d...

Hi Rick, Power Query is available in all versions of Excel with an Office 365 licence. The only limitation you will notice with the Home version is...

Hi Matthias, What version of Excel do you have? I don't get this behaviour in Office 365. Mynda

🙂 I bet you learnt loads along the way so hopefully the journey was worthwhile.