Forum Discussion
Calculate Time
Once you examined the code, replace the Source step with your own source.
does one event always finish before the other starts? No overlaps?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
The start and stop time for each day of each person is not always on the same row, I don't know how to get the total hrs for that person each day. How do I attach sample pbix file here?
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
it's frustrating... I can't share the file in onedrive because of security permission. I tried to insert to table and got error message ""Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied." Can you work with this small data set? Thanks in advance.
