Forum Discussion
Select column based on slicer
The problem is that the Gkey is also the primary key of the table, so I can't have multiple rows with the same Gkey, and unpivoting does that.
msl088 so this is a larger modelling challenge, as Ashish_Mathur suggested, create a table with unique gkey column and then use that table to link to this unpvitoed table and also with other tables you have in the model.
Data modelling is key part of any BI report and this is exactly is what we need it here.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡