sum of hours divided by the total number of hours per year.

[mjohnsen]

Hello,

I'm trying to make a measure that yields the sum of hours divided by the total number of hours per given year.

This measure gives me something similar to what I want (considering that the number of days in a year is approxemately 8760):

measure = sum(data[machine_hour_per_order) / 8760

However, it does not account for the past hours in the current year. Do you have any suggestions?

 Dummy data:

Machine	Date	Machine hour
1	01.01.2021	1000
1	01.02.2021	1000
1	01.01.2022	10
1	01.02.2022	20
2	01.01.2021	500
2	01.02.2021	500
2	01.01.2022	5
2	01.02.2022	10

The plot should look something like this:

[DimaMD · Accepted solution]

@mjohnsen Hi, Is this your desired outcome?

[mjohnsen]

Thanks! It seems like the measure does what I want. 

[v-zhangti · Accepted solution]

Hi, @mjohnsen 

You can try the following methods.
Column:

Year = YEAR([Date])

Measure:

Measure = 
Var _Sum=CALCULATE(SUM('Table'[Machine hour]),ALLEXCEPT('Table','Table'[Machine],'Table'[Year]))
Return
DIVIDE(_Sum,365*24)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DimaMD · Accepted solution]

@mjohnsen Hi, Is this your desired outcome?