Forum

Hi John, This isn't your typical Running Total so the code I wrote for Power Query Running Totals would not work without modification. So, I've ...

Hi Leah, Really difficult to give you anything other than generic advice without seeing an example of the data, and specific instructions on what d...

Hi Steven, If you can supply the file, or at least a good representative sample of the data in a file, you'll find you get a quicker response. If ...

Hi Goran, Your file isn't attached, only a screenshot. I can't quite make out the wording in the screenshot but it's a VBA error. Unless I can ...

Hi Mohamed, I watched the whole video and I think what you want to do is find a quick way of duplicating a query? In the video you right click t...

Nothing attached. Click Start Upload after selecting the file.

If you actually try to provide detail about what it is and explain clearly the result you want, it'll be much easier to help you. To start, in your...

Try these posts Running totals in Power Query Grouped Running totals in Power Query Regards Phil

Hi Michael, You can check the Description column for words that indicate the value in the Revenue column should be negative, e.g. look for "Discoun...

Hi Jan, I'm not sure if you are asking me something? regards Phil

Hi, With this Power Query course Regards Phil

Hi Francis, I understand this might be difficult as you don't know how to create a pivot table, but there's no substitute for learning. So I'd rec...

No worries. Phil

Hi Adam, Offie 365 would be better as it provides the best solution. Without that you'll have to rely on techniques shown here Excel Extract a Uni...