Calculate for every different product

Question

Hey!&nbsp;I wanna calculate the&nbsp;RunTime of a device the last 24 hours, but I am having problem to make it filter just its devices as:&nbsp;Device&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Index&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TotalRunTime (h)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(NewRunLoad)A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2046&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2040&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;B&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;(There are even more data)&nbsp;I want a column that calculates the different since the last index OF ITS OWN DEVICE.&nbsp; For example for device A 2046-2040 = 6, I tried a couple of different functions but I cant really figure it out.&nbsp;&nbsp;&nbsp;NewRunLoad =var ett = LOOKUPVALUE('Data'[RunLoad_h], Data[Index], Data[Index])var tva = LOOKUPVALUE('Data'[RunLoad_h],'Data'[Index], Data[Index]-1)returnCALCULATE(ett-tva, ALLEXCEPT(Data,Data[Device])&nbsp;&nbsp;Kind regards

liviolanzo · Accepted Answer

Anonymous&nbsp;I think this should do what you want:&nbsp;&nbsp;Column =
VAR minIndx =
    CALCULATE (
        MIN ( Table1[Index] ),
        ALLEXCEPT ( Table1, Table1[Device] ),
        Table1[Index] &gt; EARLIER ( Table1[Index] )
    )
RETURN
    IF (
        ISBLANK ( minIndx ),
        BLANK (),
        Table1[TotalRunTime (h)]
            - CALCULATE (
                SUM ( Table1[TotalRunTime (h)] ),
                Table1[Index] = minIndx,
                ALL ( Table1 )
            )
    )

Forum Discussion

Calculate for every different product

1 Reply

Related content

Different Calculations

Dynamic Calculation Different Period

calculate cumulative sales for active products

Calculating product profit margins

Calculating Differences