Forum Discussion

s_kula's avatar
s_kula
Icon for Helper I rankHelper I
3 years ago

Relation in power bi model

Hello forum users, I need help in the correct construction of the relational model, and in principle with the assignment of the cost table. I'll explain exactly what it means: Cost tables have differ...
Need Help
s_kula's avatar
s_kula
Icon for Helper I rankHelper I
3 years ago

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi s_kula ,

 

For your situation, you can create a calculated column to return the specified number of characters from the start of a text string.

SKU 2 = LEFT([SKU],2)

You can then have the calculated column in Table PRODUCT create a relationship with SKU 2 in Table COST.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • s_kula's avatar
    s_kula
    Icon for Helper I rankHelper I
    3 years ago

    Just to understand everything properly. I have a sales table with variant products attached to the product table, and several cost tables have variants and the rest do not. How will you create a relationship between the product table and the cost table when the primary key in the products table has duplicate values.

     

    Sebastian