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 (), …

In Excel, I achieved this using the OFFSET function, like so: =OFFSET (Date'Jan 2013', CNTED month, 0) Here's the breakdown: Date: Month Year format CNTED Month: Represents the …

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

Hi Christian, Unfortunately, the data structure in your sample data is one of the few that Tableau Prep doesn't handle. The ability to work across rows (especially previous and next) is one of …

error occur when creating a datasource joining database to either network shared excel file or local file. no error joining multiple tables from database. this is a new laptop. the specifications …

@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 …

Mar 6, 2019 · Vlookup/Index Match Equivalent Hi, I need to create a measure that sums up the Revenue of Prior Quarter. Something will look like below in Excel. I've attached the tbwx. Any …