Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

EARLIER funcation

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!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Please note that the MINX is a row level function, which means the expression will be evaluated for each row. Keeping this point, please check your result.

     

    If you still have issues, some sample data of what you expect. what you get will be helpful to see this.

     

    Thanks

    Raj

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Please note that the MINX is a row level function, which means the expression will be evaluated for each row. Keeping this point, please check your result.

     

    If you still have issues, some sample data of what you expect. what you get will be helpful to see this.

     

    Thanks

    Raj