Dear All,
Please kindly help me for the formula to get 1 data [Booking Code] from many table [Hotel] , [Tour] , [Ticket] which have their own [Booking Code] .
thank you so much
How can we help with the expression without knowing your table schema, column structure etc? Please elaborate the issue and support with some scrshots so we might have a better understanding.
3 Likes
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()
2 Likes