Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Lookup values from another table

Hello folks    I have 2 tables - Invoice & invoice received  Invoice Table will have invoice and line items and invoice received will have invoices but without line item  Invoice Line Item Vendor...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    Sorry for our mistake, we can create a measure to get the releated index value and used it in other visual:

     

    Invoice_exist_DQ_Measure = 
VAR I_Num = SELECTEDVALUE('Invoice'[Invoice Number])
RETURN
CALCULATE(
    MAX (Invoice_recvd[Index] ),
    Invoice_recvd[Reference] = I_Num
)

     

    Or we can merge with the Recvd table and expand the index column

     

     

    Those should work on directquery mode.


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

amitchandak 's query is great by using the Alternate_Result in LookUpValue function but it miss some parameter, please try to create a calculate column using following dax?

 

Invoice_exist = 
LOOKUPVALUE (
    Invoice_recvd[Index],
    Invoice_recvd[Reference], [Invoice Number],
    FIRSTNONBLANK ( 'Invoice_recvd'[Index], true )
)

 

 


Best regards,