-
1. Re: Can I use Lookup as Vlookup (Excel)?
Jonathan DrummeyJan 16, 2012 5:47 PM (in response to Cau? Brito)
I don't know of any vlookup function in Tableau, but I think there's another way to do this: You can create a table calculation such as WINDOW_AVG(AVG([Amount])) and set the Compute along ID and Date. This will cause Tableau to perform the average calculation for each ID and date, and since all the results are the same for the given ID/date combination (I assume) then you will have the correct result. I've attached a workbook that shows this. The one thing I still have difficulty with in table calcs is that they can return multiple values, like this one does, even though all the values are the same.
-
average_amount.twbx 32.7 KB
-
-
2. Re: Can I use Lookup as Vlookup (Excel)?
Duong Vu Aug 8, 2016 8:04 PM (in response to Jonathan Drummey)dear Mr. Jonathan
I have same issue with Mr Cau.
it is like that :
we have 1 table data
date Item Q'ty
1/1/16 A 1
1/1/16 B 2
1/2/16 A 5
1/2/16 C 7
Request to find as same :
item 1/1/16
A ????
B ????
C ????
D ???? D: don't have in table, but still need display value 0 , this request is easy if we use vlookup in excel.