Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over x …

Hi, Kindly use Lookup function in tableau to offset your field. Kindly take the reference from above screenshot. Thanks, Kalpit

Hello @Rohan Fernando (Member) , Tableau works against tables, whereas Excel works against individual cells, so achieving both a horizontal and vertical offset will be tricky, as we shall …

Nov 2, 2017 · Hi All Trying to get value's compared in the lookup function where they are not in the same partition, see attached screenshot I have also tried using the functions like size (), …

I would need to create a built in rule that identifies the data that should be used create the offset. There are identifying columns that ID the data in the row; year, comp, round, match, team

Jan 26, 2016 · Hey Dan, if your DB table is in SQL, and you have a field that stores Customer's Time Zone, This should be easy to do on your DB query by using the AT TIME ZONE function …

The graph is in the "Offset" sheet of the workbook. I've attached a mock of how how the graph would ideally look in case my explanation has not been clear enough.

@Diego Martinez (Member) , I have a same question for the excel function "WORKDAY.INTL ()" The function takes a date and returns the nearest working n days in the future or past, based …

Hi John, So, there's a workaround method of LOOKUP () in Prep that works for many (not all) instances using a RANK () function on the primary flow, which helps establish initial row order; …

In Excel/Power Query, I am able to create a power pivot lookup table for both the Lead Source/Location fields by connecting & mapping that lookup table to both the Lead and …