Many to Many Raltionship issue

[Anonymous]

Hi All,

I have a doubt in the below blog:

https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/

If i dont have unique Invoice (just for assumption) then i will be getting many to many relationship issue.

How to overcome such scenarios when we dont have primary key column in the table.

Thanks in advance.

Regards,

Prakash 

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can add a Index column as the invoice column to connect other table.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.