locked
duplicate values and relationships RRS feed

  • Question

  • Hi 

    Trying to follow this self-study

    https://support.office.com/da-dk/article/selvstudium-udvide-datamodelrelationer-ved-hj%C3%A6lp-af-excel-power-pivot-og-dax-cf7197d3-1938-490e-93fb-20371e8dd67a 

    But when i have to combine EditionID.Medals with EditionID.Værtsnation it claims duplicate values, but in the file EditionID.Værtsnation there is 0 duplicate values. (microsoft file and also checked in excel with remove duplicates etc)

    What to do? 


    Monday, November 19, 2018 8:44 AM

Answers

  • At a guess, you may have been trying to create this relationship in the wrong direction. So double check which table should be on the many side and whilch should be on the one side of the relationship and make sure you've specified this correctly.

    http://darren.gosbell.com - please mark correct answers

    Monday, November 19, 2018 10:12 AM