Last seen: Aug 26, 2025
Needed to reply to the lastest post in order to moderate it. Unfortunately, I'm in no position to help you with VBA 🙂
Not sure I understand what exactly you are looking for, but perhaps that the PT in the attached file is a start. If not, please specify what "max conc...
Maybe, but I still don't understand. If 'Yes' would become 1 and 'No' would be 2, 3 yes and 2 no would average to (1+1+1+2+2) / 5 = 1.4. But does tha...
I created an area with formulas (I30:O41) that do what I think you need. But please check, since my numbers don't match the ones you entered manually....
Please upload your file (not a screenshot). I will be much easier to help that way.
Go to 'Pivot Table Options' and make sure that the 'Retain items deleted .......' switch is set to None. That should fix it.
No I don't know what's correct, but remember the guy from the video mentioning that the +1 was needed because he wanted to include the start date in t...
Glad it works then. Regarding the "better way", just follow the YT-video you included in your first post. It explains a much easier approach.
In this case I would add an "index" column containing sequential numbers starting at one. These will be the row numbers for each part of the trip. The...
Why did you choose to go the complicated way with List.Generate, creating tables and then merging them? The approach in the video is much simpler. But...
You mention working days and that the file contains projects without an end date. However, the file seems to be set up to calculate working hours and ...
What I meant is that you need to explain how you would calculate such an average.
You seem to be quite advanced in DAX and it's difficult for me to add anything without seeing your file/model. However, you may want to look into the ...
Great! Perhaps one of the other frequent contributors here can help with a more solid (DAX) solution for you.
I see what you mean but can't really get my head around how to do this with DAX measures in PP. Most likely I would do the ground work in Excel before...
