Forum Discussion
Solved
Calculating Hourly Usage Data based on last entry
Seems like a simple problem however I cannot find a solution. Can anyone assist? Operators use a piece of equipment and then enter a series of checks for mainteance Items. Within that they enter...
Sorry, none of the responses below I was able to get working. I even bought the Russo and Ferrari book to try to understand the Earlier Function.
I solved it within the source data.
=IF(ISBLANK(D2),"0",Iferror(D2-large(QUERY($C$2:D2,"Select D where C matches '"&C2&"' order by D desc limit 2"),2),0))
Line C is my vehicle ID and Line D is the hour reading the operators input each day.
A response I received on email. Couldn't get it to work.
Matt
Column = CALCULATE(MAX('T2'[Type]),FILTER(ALL('T2'),'T2'[ID]=EARLIER('T1'[ID]) &&'T2'[Date]<=RELATED(T1[Date])))