Forum Discussion
Count days between dates if specific column is > 0
Super User"OBS: Some start and end dates can overlap"
Please explain what to do in such a scenario.
It was only an information with regards to how to identify them seperately
So a person can be allocated to Project 1 for 3 hours and Project 2 for 7 hours the same day,
In the end if i sum it up he will be booked for 10 hours in total on one day.
My main problem is after getting a list of days between the to dates how to destingues between workday or of day that is based on the other table if the value on that specific date is larger than 0.
I have managed to split this out to a list of date between the dates for each ALL.ID.No
So i need to count for each serie/list of date for a project All.ID:No the number of dates with a value higher than 0 in allocation. and write in a new column
When i have managed that i think i am good to go from there
Hope this helps a little
- lbendlin
"
So a person can be allocated to Project 1 for 3 hours and Project 2 for 7 hours the same day,
In the end if i sum it up he will be booked for 10 hours in total on one day. "
Still not clear.
Let's say they are assigned to project A from 9 am to 12 pm and to project B from 10am to 5pm. How many hours total?
I Have made a simple power bi file, that may help understand my problem, But how do i attach it?
What format
I have have refraised the original question hope this clarifies something
