Forum Discussion

Resolver III

6 years ago

Performance Issue with EARLIER

Hi Guys, In my dataset I am getting Individual IDs, Start Time, End Time and Index. We are recording entry and exit times of Individuals using multiple source so these Start and End Time can be...

Need Help

v-lili6-msft

Community Support

6 years ago

hi Mann

You need to use Variables in the formula instead of EARLIER

Column 5 = 
VAR _Index = Table1[Index]
VAR _IndID = Table1[Ind ID]
VAR _MaxEndTime =
    CALCULATE (
        MAX ( Table1[End Time] ),
        FILTER ( Table1, Table1[Ind ID] = _IndID && Table1[Index] <= _Index )
    )
RETURN
    IF ( Table1[End Time] = BLANK (),1, IF ( Table1[End Time] < _MaxEndTime, 0, 1 ) )

Column 4 = 
var _Index=Table1[Index] return
VAR _MaxEndTime= 
CALCULATE (
    MAX ( Table1[End Time] ),
    FILTER (
        ALLEXCEPT(Table1,Table1[Ind ID]),
            Table1[Index] <= _Index
        )
    )
Return
IF(Table1[End Time]=BLANK(),1,IF(Table1[End Time]<_MaxEndTime,0,1))

https://exceleratorbi.com.au/using-variables-dax/

Regards,

Lin