Forum Discussion

khisla's avatar
khisla
Helper II
1 year ago
Solved

X Lookup within same table

Hello Community I have the below data columns withiin my table and need to get the below result (i.e. original receipt date column). I need to x-lookup the retrieved from receipt no. within the rec...
  • Fowmy's avatar
    Fowmy
    1 year ago

    khisla 
    Add the following Calculated Column to your table, rename the table as per your model":

    Orignal Receipt Date = 

VAR __Rno = Table02[Retrieved from Receipt No.]
VAR __Date = MAXX( FILTER( Table02 , Table02[Receipt No.] = __Rno ) , Table02[Date] )
RETURN
    __Date

     

     

     

Fowmy's avatar
Fowmy
Super User
1 year ago

khisla 
Add the following Calculated Column to your table, rename the table as per your model":

Orignal Receipt Date = 

VAR __Rno = Table02[Retrieved from Receipt No.]
VAR __Date = MAXX( FILTER( Table02 , Table02[Receipt No.] = __Rno ) , Table02[Date] )
RETURN
    __Date