Forum Discussion
TuqueLogic
Helper I
Helper IDAX getting MIN value from rows with same value in different column
Feel silly asking as this seems like it should be simple. Looking to create a new column for a table that contains the Min 'Start Date' value for rows that have the same InitialResultID. IE just ...
EARLIER seems to do it:
CALCULATE(MIN(table[StartDate]), FILTER(table, TestBillingAgentTasks[InitialResultID]=EARLIER(table[InitialResultID])))
Here it states EARLIER refersto the previous 'table scan':
EARLIER - DAX Guide
Can someone point me to where I can understand better what table scans are, where in the code they are initiated, and by which types of functions?
TuqueLogicHelper I
Helper IEARLIER seems to do it:
CALCULATE(MIN(table[StartDate]), FILTER(table, TestBillingAgentTasks[InitialResultID]=EARLIER(table[InitialResultID])))
Here it states EARLIER refersto the previous 'table scan':
EARLIER - DAX Guide
Can someone point me to where I can understand better what table scans are, where in the code they are initiated, and by which types of functions?