Forum Discussion

HitcH's avatar
HitcH
Icon for Helper II rankHelper II
3 years ago

Tables connection not working

Hi everyone

I have three different tables.

1) Document number and its value

2) Document number and customer

3) Customer and customer details

 

The three tables are linked:

 

I want to create a table with customer and value of the document numbers linked to those customer, but it is not working:

 

Any idea about how could I do that?

 

Thanks in advance

 

Need Help
Tips and Tricks

9 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    HitcH 

    1) Document number and its value - let's call it Table1

    2) Document number and customer - let's call it Table2

    3) Customer and customer details - let's call it Table3

     

    First relatinship - Table 1 will join with Table 2 on document number, with 1 to many relationship, 1 on Table 2 side and many on Table 1 side.

     

    2nd relationship - Table 2 will join with Table 3 on customer number with 1 to many relationship, 1 on Table 3 side, and many on Table 2 side.

    • HitcH's avatar
      HitcH
      Icon for Helper II rankHelper II
      3 years ago

      The problem is that the one that you call "Table 2" (in my screenshot it's the "LPT Delivery") has many documents with the same number because they are related to the different products, so the relation has to be "many to 1" instead of "1 to many".

      I need to have a sort of vlookup in which I could connect "many" document numbers to the customer

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    HitcH this is how it should work:

     

    Document with Value will connect to document with customer on document number

    document with customer will connect to customer on customer number

     

    and now you can use customer from customer table and value from the value column

    • HitcH's avatar
      HitcH
      Icon for Helper II rankHelper II
      3 years ago

      But that is exactly what I did, and it is not working... 😞

    • HitcH's avatar
      HitcH
      Icon for Helper II rankHelper II
      3 years ago

      Then I'm sorry but I couldn't understand your explanation, can you add some more details?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    HitcH seems like we both are talking about different things now. Better to put some sample pbix file and share them using one drive/google drive. remove sensitive information before sharing.