Sum hours by shift in a mounth

[gersonplovas]

Hello evebody!

I need some help here.

That is the question:

There is a company that works in 3 shifts per day and some equipments works 2 **bleep**fs and others equipments works 3 shifts.

The equipaments A works 2 shifts and the equipaments B works 3 shifts.

I have a table dCalendar with the shifts and a table with the equipaments works description.

I need to sum the total hours worked per each equipments in a mounth.

Thanks for now.

[amitchandak]

@gersonplovas ,Can you share sample data and sample output.

[gersonplovas]

dCalendar with time shiftTable equipament shiftI tried to do it but doesn't workedSure,

[v-frfei-msft]

Hi @gersonplovas ,

I cannot access your file by your link, Could you please share it again? 

Btw, please try to use this formula.

total =
CALCULATE (
    SUM ( dCalendar[T1] ),
    FILTER ( equipament, equipament[turnos] = "1" )
)
    + CALCULATE (
        SUM ( dCalendar[T3] ),
        FILTER ( equipament, equipament[turnos] = "3" )
    )

[gersonplovas]

Hi @v-frfei-msft  ,

Thanks for reply,

I did as you said but it didn't work, because the sum of the hours by equipaments is the same for all of them I don't have the sum of the shift hours slice by equipaments.

Please check it below.

Is there another way to share it to you?

Have a good one.

table d Calendar with hours shift

table equipment work shift

[amitchandak]

@gersonplovas ,

Sorry not able to get you, data model. Please provide data in a tabular format with the expected output.

[gersonplovas]

First of all thanks for helping me.

Sorry for it I am new here

Can you able to open the link below?

https://app.powerbi.com/groups/me/reports/67c540b9-c4dc-42ce-bc50-ffaf9120e14b?ctid=52130f36-b8f4-4f... 

[gersonplovas]

https://tigre-my.sharepoint.com/personal/gerson_plovas_tigre_com/Documents/%C3%81rea%20de%20Trabalho...