Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Eliminate Many 2 Many Relationship

Hi,   I am facing the issue while building many 2 many relationship, so far it works well when I want to display sales vs actual as per month, location, but when it comes down to customer codes, I ...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

Anmolgan , Screenshot missing. But if there is more than one name. You can go in edit query/Data transformation, right-click on column and delete duplicate values 

 

Or create a new table

summarize(Table, table[ID],"Name", max(Table[Name]))

  • Anmolgan's avatar
    Anmolgan
    Post Prodigy
    6 years ago

    Hi amitchandak can you help me resolving the issue, I will share you the pbix, let me know if it will be possible for you to look into this

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anmolgan , share the pbix, I will try to check

      • Anmolgan's avatar
        Anmolgan
        Post Prodigy
        6 years ago

        Hi amitchandak, I have shared the PBIX link for the report, let me know if you can access it.