cancel
Showing results for
Did you mean:
Frequent Visitor

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

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:

2 ACCEPTED SOLUTIONS
Super User

@mjohnsen Hi, Is this your desired outcome?

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine
Community Support

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.

3 REPLIES 3
Frequent Visitor

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

Community Support

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.

Super User

@mjohnsen Hi, Is this your desired outcome?

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors