Forum Discussion

PGG79's avatar
PGG79
Frequent Visitor
1 year ago
Solved

PowerBI Model time dependant

Hi I have two tables. In one I have the technicians' hours recorded on a date, here is the example: Technician Recording date Hours recorded  Tech1     2023/01/01    8       Tech2    ...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi PGG79 ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you lbendlin  and SundarRaj  for the response.

     

    I have worked on your sample data and attached the PBIX file with the results. Please review it and let us know if it is helpful. If you have any further questions, please provide more details.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!

PGG79's avatar
PGG79
Frequent Visitor
1 year ago

Hi lbendlin 

that's the way the information is coming from the source system. The assumption is that the recording is done in working days within business hours. For the report we don't care.

for me the main problem is how I can do the model to know the workingschedule valid for the day the hours were recorded. Thank you!

lbendlin's avatar
lbendlin
Super User
1 year ago

I cannot assist you with that in a meaningful way.I hope someone else can help you further.