Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How to get value from another table based on multiple criteria

Hello,   I'm in stuck with my problem. Let's say I have 2 tables: Quotations and Shipments:   Quotations table: Branch Department QuoteID Local Client SrvLevel Origin Destination Start...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello ChrisMendoza,

 

Trying to follow your guideline but below error occurs:

 

 

what am I doing wrong?

 

Thanks, Tomas

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
8 years ago

Anonymous, 

 

Seems like you do not have a relationship between the two tables. When I loaded your sample tables, Power BI established the relationship as the below for me:

 

 

Is your's not similar?

 

For Reference RELATED ( ) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi ChrisMendoza,

     

    Relation is working if LocalClient is unique but if I add another Quotation for the same client but different Start and Expiry dates (very last  row in below table) then relations dissapearring and your formula is not working.

     

    BranchDepartmentQuoteIDLocal ClientSrvLevelOriginDestinationStart DateExpiry Date

    BR2241QMT200002851Customer1LIFNLRTMDEBRV2018.06.022018.06.30
    BR2241QMT200002852Customer2FILNLRTMDEBRV2018.06.022018.06.15
    BR2241QMT200002853Customer4LILKRPUSDEBRV2018.06.022018.06.30
    BR2241QMT200002854Customer5LIDKRPUSDEBRV2018.06.022018.06.30
    BR2241QMT200002855Customer7LIFDEHAMDEBRV2018.06.022018.06.30
    BR2241QMT200002856Customer8LIFDEHAMDEBRV2018.06.022018.06.30
    BR2241QMT200002857Customer9LIDCNSHADEBRV2018.06.032018.06.15
    BR2241QMT200002858Customer10LIFDEHAMDEBRV2018.06.012018.06.30
    BR2241QMT200002859Customer10LIFDEHAMDEBRV2018.07.012018.07.31

     

    Any thoughts how to solve such case?

     

    Thanks in advance!