Unpivot table

[JustNewbie]

Hi, 

Currently Table 2 is connected to Table 1. Relationship is One to Many (Table 2 Reference is unique, Table 1 Reference will duplicate.) Now I want to unpivot Column F,G,H,I in Table 2. Problem here is if I unpivot, the reference number in Table 2 will become duplicate and not unique, it affects my Table relationship become many to many. Result will incorrectly display when I create visuals. How do I solve this issue?

[Dhairya · Accepted solution]

Hey @JustNewbie 

If you are using Table 2 as a slicer then as a workaround you can take a duplicate of Table 2 and unpivot that duplicate table so your Table2(older one without unpivot) will have 1 to many relationships with Table 1 and Duplicate of Table, So by this way you handle this.

If this works for you then please mark my solution as accepted so that it can help others too. Thank you!

[JustNewbie]

thanks, does it means I need to have table 2 & duplicate table 2 connected to Table 1? 

[Dhairya]

No relationship will be like
table2    1 to many      table1
table2    1 to many      table2 duplicate(unpivoted)

[Dhairya]

Hey @JustNewbie 

If this works for you then please mark my solution as accepted so that it can help others too. Thank you!