Forum

Hi Catalin I want to combine all data source files with my main file and take parts of data from these in Power Pivot and charts. Erik

Hi Mynda and Phil I have made a file with simple mockup data and in two sheets tried to show to show you my challenge and my idea of a solution. ...

Hi Mynda and Phil The data is from work and rather sensible, but as an example this could be part of a file: District - number and text - I on...

Hi Mynda I understand that, but it wouldn't make a whole lot of sense to me to buy the 365 version, when my comany ( with more than 11.000 employee...

Hi again Mynda It seems to me, that Microsoft isn't going to answer this one. I understand that developement is for Excel 365 users only, but I ...

Hi I have been having the same issue using Excel Power Query and found a solution. If you edit your query and remove queries from files beginnin...

Allready on my next project at work - budget on salary expenses for 600 + emplyees for the next 4 years I look forward to your Power Pivot course ...

Hi Mynda With a lot of trial and error, I finally succeed in finding a solution that works. I have shown it to upper management, and it has already...

Hi Mynda Guess my next online course will be your Power Pivot course After a lot of try and error, I finally got it - thanks a lot. Erik

Hi Mynda Thanks a lot - knowing a bit about databases, I should have known about the Calendar table. But - tried to use the same data in a ...

Hi Mynda and Phil I have made a simple example - Pivot tables from data - danish and english - no problem sorting weekdays in the correct order. ...

Hi again Phil I took the simple data set and used it in Power Query - same problem - Power Query sorts weeksdays ( in danish ) in alphabetical orde...