Transform Scheduled Time Data to get to Total Time Scheduled Measure

[Anonymous]

Hello,

I have a data table I need to transform in order to get to Total Time Scheduled by employee. The data table is currently set up in a very odd format and I can't think of the most efficent way to transform it. Below is a sample image of the data fields we are working with. There are so many options in terms of repeats, repeats every 1st week, 2nd week etc. and then specific days of the week. Any thoughts on how I could get this into a useable format??  

[Anonymous]

@Anonymous 

I don't see any way in Power BI to calculate the total time with current table. I guess you would need to recreate your model.

You should always have a calendar instead of date start and date end when calculating working days/time. My suggestion is turn the table to a format with a date column and a weekday column, create a flag column and working time column. For example display 1 if the employee worked in the day and record the working time on each worked day. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Again,

I have attached a link with an example copy of the data in image I provided above. Apprecaite the help!

https://drive.google.com/file/d/1h7tYFBVfq2wke8114JvEcobNWZXAhh70/view?usp=sharing