Forum Discussion
Count days between dates if specific column is > 0
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
Super User"
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
- lbendlin
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523