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])...
  • 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