Forum

Hi Riny This is exactly what I wanted - thanks a lot. The added custom list (=List.DateTimes([#"Start date & time"],[Hours],#duration(0,1,0,0)...

Took the solution to work only to find out, that TREATAS isn't working there - Excel 2016 32 bit is the "tool", I have to work with there. Hope som...

Hi Riny Thanks a lot. My plan was to be able to make a profile for each department and each individual employee. Guess I can use your tip on ...

Trying to upload again

With a simple example file, where employee# is the common denominator, I hope to be able to illustrate the challenges I'm facing with data from work. ...

Hi Riny I got that far myself, but the problems started with the different data regarding - hours worked, completed days of holiday, days sick and ...

Hi Catalin That is what I have been trying to suggest - maybe in other words - but this was my idea. Guess you agree with me, that it can be don...

Hi Catalin I am not going to combine the data source files in Power Query - only in the data model. With unique column headers ( copying the case#...

Hi Catalin Thanks - but this is not the issue with my data sources. They consist of up to 12 different data files with different contents, and o...

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. ...