Forum Discussion

dokat's avatar
dokat
Post Prodigy
3 years ago
Solved

Linking Tables

Hi,   I have two tables that i am trying to link using common identifier and bring the corresponding values from one table to another. When i import the table and link with the common identifier (P...
Need Help
dokat's avatar
dokat
Post Prodigy
3 years ago

Thank you Ashish. I link the tables similar to what you did however Gross Sales outputs shows as sum. It doesnt show corresponding values for each brand.  Please see below

 

if it helps ic an share the .pbix file with you. Thanks

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Study my solution carefully over and over again before you give up.

    • dokat's avatar
      dokat
      Post Prodigy
      3 years ago

      Yes, i have been trying but the issue i am coming across is when i connect product hierarchy i cant establish Many to one relationship i thinks thats what causing the eror and there is no way around it.