Forum Discussion

klee7290's avatar
klee7290
New Member
2 years ago
Solved

Modeling Relationship

I have a unique issue that I am not sure can be solved.    I have two data sets with the following fields: -Table A - Spend family, Category, Sub-category, country, global lead, regional lead -Ta...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi klee7290 ,

     

    Thanks for the reply from NaveenGandhi .

     

    Please consider adding an additional field, lead, to the connection string to make it truly unique.

     

    For example: country category sub-category lead.

     

    This can be done in Power Query.

     

    If you have any other questions please feel free to contact me.

     

    I would be grateful if you could provide me with pbix file, please remember not to log into your account in Power BI Desktop when uploading the pbix file.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!