Forum Discussion

dokat's avatar
dokat
Icon for Post Prodigy rankPost 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
Icon for Post Prodigy rankPost 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
Icon for Super User rankSuper User
3 years ago

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

  • dokat's avatar
    dokat
    Icon for Post Prodigy rankPost 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.