Forum Discussion
Count days between dates if specific column is > 0
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