Forum Discussion
Solved
Unpivot table
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 ...
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!
thanks, does it means I need to have table 2 & duplicate table 2 connected to Table 1?
No relationship will be like
table2 1 to many table1
table2 1 to many table2 duplicate(unpivoted)
Hey JustNewbie
If this works for you then please mark my solution as accepted so that it can help others too. Thank you!