Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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):
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:
Solved! Go to Solution.
@mjohnsen Hi, Is this your desired outcome?
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.
Thanks! It seems like the measure does what I want.
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.
@mjohnsen Hi, Is this your desired outcome?
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |