Calculate hours of accidents

[Syndicate_Admin]

Hello Community,

I need to calculate the hours of accidents.-

I have a table (Bd Accidents) with the Start and End Date of an accident:

On the other hand, I have my calendar table, where I have determined the working days and the hours that correspond to each day.

I would like to create a measure, which adds the number of hours ( Hours Day of the calendar table ), for the days in which each of the people was injured (Table BdAccidents).

I will appreciate your help.-

Slds,

[Ashish_Mathur]

Hi,

I think the approach should be to create one row for each date (between the start and end date) in Table A.  Then create a relationship (Many to One and Single) from this Date column and the Date column in the Calendar Table.  To your visual, drag any date field from the Calendar Table.

[Syndicate_Admin]

Dear

Is there a function that does it automatically? or would you be proposing that it be done manually?

[Ashish_Mathur · Accepted solution]

Hi,

It can be automatically in the Query Editor using

{[StartDate]..[EndDate]}

You can then expand this new column.

[amitchandak]

@Syndicate_Admin , You can create a time table join it with time part, it can have hour to group data hour wise

https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...