Error in my code?

Question

Hey!&nbsp;Can anyone see what gets wrong with my DAX formula?&nbsp;I write following:&nbsp;&nbsp;NewRunLoad = &nbsp;VAR minIndx =&nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MAX ( Data[Index] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLEXCEPT ( Data, Data[Device] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Data[Index] &gt; EARLIER (Data[Index] )&nbsp;)&nbsp;RETURN&nbsp;IF (ISBLANK ( minIndx ),BLANK (),Data[TimeLoaded_LC]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM ( Data[TimeLoaded_LC] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Data[Index] = minIndx,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT(Data,Data[Device] )&nbsp; ))&nbsp;&nbsp;&nbsp;This is what TimeLoaded_LC is, and this is what NewRunLadoad gets:&nbsp;&nbsp;I want it to take the current value, - previous value. as 988 - 987.9 = 0.1 and this value to be in NewRunLoad.&nbsp;&nbsp;Thanks!&nbsp;Kind regardsAgnes

v-yulgu-msft · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
Please refer to below DAX formula:
NewRunLoad =
IF (
    CALCULATE (
        MAX ( Data[Index] ),
        FILTER ( ALLEXCEPT ( Data, Data[Device] ), [Index] &lt; EARLIER ( Data[Index] ) )
    )
        = BLANK (),
    BLANK (),
    Data[TimeLoaded_LC]
        - CALCULATE (
            SUM ( Data[TimeLoaded_LC] ),
            FILTER (
                ALLEXCEPT ( Data, Data[Device] ),
                [Index]
                    = EARLIER ( Data[Index] ) - 1
            )
        )
)

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

Error in my code?

2 Replies

Related content

Error Code: 9518

Error code 20302

error in this code

Error code: ActionUserFailure

Workload Error Code PersonalGateway_ShortMessage_PublishingError