Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |