I am trying to find out the distance between 2 latlong field. The situation is this : I have sales team members are in different areas. They need to punch every 1 hr in selected areas.
But I need to get the last punch area(latlong field) for the particular team members. This means that if a person A is going to punch, i need to find out the the previous latlong field lastly. Thanks
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?
How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()
thank you. It is working fine. Thanks for your immediate reply
1 Like