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, How do i offset my numbers to the next month or previous or previous record in the dimension. It was easy in Power BI using the time intelligence function. But I dont know how to do it in …

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

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 …

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 …

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 …

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 …

All Answers James Emery (Member) 2 years ago @VadymK K (Member) LOOKUP does work (vlookup is an excel function, not Tableau). You have two options. Because you have your …