Hi, I have a problem that I cant find works hour and break hour in my data. I only found this line:
Now I might think that this line can get the works hour and breaks hour but i dont know how to solve it.
2. Either can or cannot, can i separate this line to Monday, Tuesday,..., Sunday?
you have not provided much context here, but assuming you are working in power bi desktop in import mode, you can solve this with power query.Find the transform button:
Cheers,SturlaIf this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Split the sting first by semi-colon, then by comma:
Then play around with the pivot-functions to change the columns to rows
I think its cant help me. I have two questions.
1. can I get work hour and break hour from the recurrence pattern: FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
2. can I get Day(Monday, Tuesday, Wednesday, Thursday, Friday, Saturday,Sunday) from the recurrence pattern:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
This is the work hour and break hour that i need
If this is the data you have:
you obviously cannot get work hours and break hours directly from this, as it does not contain any information about this. If you can assume a fixed number of hours each day, you can use the method I described, using power query, and adding a few steps to calculate the number of hours.Look at the attached file:
Find out who won the T-Shirt Design Challenge and the top 3 finalists.
Find out more about the March 2023 update.
In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.