Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Lookupvalue not working

Not clear why this is not working.    I am trying to look up the RMA number from the RMAItems table (middle table), and bring the RMA number over to my Sales table.   You can see I have both the original order number and line on the RMA table, and of course on the Sales table.   

 

I am not getting any error message...just not getting any results at all in my lookup column.    I've used two criteria  (order, and order_line) to try and make improve the search.    

 

Lookup RMA = LOOKUPVALUE(RMAItems_Query[RMA Number],RMAItems_Query[Original Order],SalesOrdersALL[Order Number],RMAItems_Query[Original Order_Line],SalesOrdersALL[Order_Line])
 
The expectation is that the lookup formula would find WC-0153245 and return back RMA-010923 to my sales table.  
 
Thanks in advance for any help!

 

 

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ashish_Mathur    Yes, it is written as a calculated column: 

       

      LOOKUPVALUE (
          RMAItems_Query[RMA Number],
          RMAItems_Query[Original Order], SalesOrdersALL[Order Number],
          RMAItems_Query[Original Order_Line], SalesOrdersALL[Order_Line]
      )

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        5 years ago

        Hi,

        Share the link from where i can download your PBI file and clearly show the problem there.