Forum Discussion
Helper VCreate a new column from other column
Helper VHi az38
it was no relationship but I created:
- From Kit[Product] to Kit Category[Product] many to one.
The error only appears when I want to add the Type column. If I deleted it, I have a table named Kit Category with two columns; Country and Product.
Thanks for your help.
Community Championso, jlarques
as i understand it works without type column because each product in your data source has the only category.
but when you add "type" column, you get a few rows with the same product and category but with different types
as you have a many-to-one relations it became impossible, because many product from Kit table have relations with many products from Kit Category
for my point, the best solution is to create in Kit table calculated column
SurrogateKey = concatenate('Table'[Product];concatenate('Table'[Category];'Table'[Type]))
then try to build a master table:
KIT CATEGORY=
DISTINCT(
KIT[SurrogateKey]
)
and create a relationship many-to-one by this SurrogateKey field
do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin
- jlarques
Hi az38
thanks for your quick answer.
When I try to create a calculated column on the KIT CATEGORY table, the Concatenated formula cannot show me any table, only the KIT CATEGORY fields, so, I cannot add other external columns from the KIT table.
Any ideas?
Thanks again.
- az38