Forum Discussion
lbrissy
3 years agoNew Member
Table relationship - option greyed
Hi, I am new to the community and quite new to PowerBI so my question is pretty basic! I am trying to create a one-to-many relation between two tables but this option is greyed. Can someone guides...
lbrissy
3 years agoNew Member
Hi,
Thank you both for your replies. It appeared the option was greyed as I had a duplicate hiding in my UNIQUE "Locations" table.
That said, the relationships between my 4 tables still do not seem to work properly, as I cannot use the function Related - as I would like.
I would like to use the function Related to convert my volumes, which are in local currencies, into euros. Currency values depend on countries and on dates.
Could you provide a tip to help?
I am grateful