Hi,
I'm a bit confused by the EARLIER function. Here is my formula:
DISPATCH_TIME = MINX(FILTER('Query1','Query1'[EVENT_NUM]=EARLIER('Query1'[EVENT_NUM])&&'Query1'[UNIT]=EARLIER('Query1'[UNIT])&&'Query1'[UNIT_STATUS]="DP"),'Query1'[CREATE_DT_FORMAT])
So the formula will return for me the earliest CREATE_DT_FORMAT value where the Event Num and the Unit match and the Unit Status = DP.
The part that I am finding confusing is, when I have my table filtered to only a specific Event Num, and a specific Unit the Create_DT_Format value is correct.
However, if I look at the exact same record when my table is not filtered, the value returned for the Create_DT_Format is not correct, it is often pulling from the next row up.
Is this how EARLIER works and I should not be worried about the value when my table is not filtered?
Thanks!
I'm a bit confused by the EARLIER function. Here is my formula:
DISPATCH_TIME = MINX(FILTER('Query1','Query1'[EVENT_NUM]=EARLIER('Query1'[EVENT_NUM])&&'Query1'[UNIT]=EARLIER('Query1'[UNIT])&&'Query1'[UNIT_STATUS]="DP"),'Query1'[CREATE_DT_FORMAT])
So the formula will return for me the earliest CREATE_DT_FORMAT value where the Event Num and the Unit match and the Unit Status = DP.
The part that I am finding confusing is, when I have my table filtered to only a specific Event Num, and a specific Unit the Create_DT_Format value is correct.
However, if I look at the exact same record when my table is not filtered, the value returned for the Create_DT_Format is not correct, it is often pulling from the next row up.
Is this how EARLIER works and I should not be worried about the value when my table is not filtered?
Thanks!