Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Looking to solve a value with measure.

I have a value of "engine hours" reported daily. I am looking for a measure to tell me the avg number of hours this machine is using in a day. The measure I am using is erroring out.  Any help would ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried

 

last date (hours) -  First date (hours) / 5 (working week). 

However, it says first date and last date are a yes/no option. 

mdgene's avatar
mdgene
Icon for Helper I rankHelper I
4 years ago

It depends on a lot of things I cant see. but have a look. if you have a data set in this format

 

then simply create your measures

 

YestedayHours = SUM('Hours Table'[Hours])
TodaysHours = SUM('Hours Table'[Hours])
 
and you can do your calculation on it using
calcavg = DIVIDE(
([YestedayHours] - [TodaysHours]),
5,
0)
or
Calcavg2 = AVERAGE('Hours Table'[Hours])

 

 

but it depends on your data structure and what you are trying to achieve.

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This is my table. I'm looking to have an average of the difference per day/week.