LOOKUP with Tableau (USED Case) 

💥Tableau Community Question and Solution Link
►community.tabl...
Table Calculation Functions
Version: 2021.2
LOOKUP(expression, [offset])
Returns the index of the current row in the partition, without any sorting with regard to value. The first row index starts at 1. For example, the table below shows quarterly sales. When INDEX() is computed within the Date partition, the index of each row is 1, 2, 3, 4..., etc.
Example
For the third row in the partition, INDEX() = 3.
LAST( )
Returns the number of rows from the current row to the last row in the partition. For example, the table below shows quarterly sales. When LAST() is computed within the Date partition, the offset of the last row from the second row is 5.
Example
When the current row index is 3 of 7, LAST() = 4.
LOOKUP(expression, [offset])
Returns the value of the expression in a target row, specified as a relative offset from the current row. Use FIRST() + n and LAST() - n as part of your offset definition for a target relative to the first/last rows in the partition. If offset is omitted, the row to compare to can be set on the field menu. This function returns NULL if the target row cannot be determined.
💥FREE TRAINING
► www.tableau.co...
► www.tableau.co...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🗣 CONNECT WITH ME ON SOCIAL Facebook ► / tableauinfo Twitter
►Twitter
/ riteshbisht01
Linkedin ► / ritesh-bisht-22238913
Tableau Community ►community.tabl...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tableau Online experience ► • The Tableau Online Exa...
Specialist Guide ► mkt.tableau.co...
Mock tests ►
www.tableauinfo...
5 golden points(both Specialist & Qualified) ►
www.tableauinfo...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 👋 ABOUT ME: My name is Ritesh, a Data Science enthusiast & trainer, ranked as high as 15th in the Tableau World Community, I hold both Tableau Desktop Qualified and Server Qualified certifications. I love to train people and blog@tableauinfo.com ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Please leave all questions and comments in the contact section or visit our website: www.tableauinfo... Subscribe Now! (Channel by Certified Tableau Data Monarch,Tableau Ambassador Ritesh Bisht)
#tableaucertification
#tableau