Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional table relationships

Hello,   I have 3 tables, Sales, Store and DistributionCenter. And these are my tables schemas em relationships:     Sales   Store   DistributionCenter storeID  ----> storeID     ...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    8 years ago

    Anonymous we can try this by adding new column in sales table:

     

    Dist Name = 
var d= RELATED(Dist[distributionCenterName]) 
return if(Sales[specialCode]=2, LOOKUPVALUE(Dist[distributionCenterName], Dist[distributionCenterID], 3), d)

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

parry2k, thanks for helping me. I known that I can do that. But I do not want to change my relationships. So is it possible to do it without changing it?

parry2k's avatar
parry2k
Super User
8 years ago

Anonymous we can try this by adding new column in sales table:

 

Dist Name = 
var d= RELATED(Dist[distributionCenterName]) 
return if(Sales[specialCode]=2, LOOKUPVALUE(Dist[distributionCenterName], Dist[distributionCenterID], 3), d)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    parry2k, thank you, your solution solved my problem!