Forum Discussion

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
4 years ago

Calculated Column with multiple tables connected in a star schema

Hi All,  I have table related like below : I am in data blending mode i.e. I have connected to live dataset and then added it as a local to do transformations (Direct Query Mode) Goal : I ...
Need Help
YukiK's avatar
YukiK
Icon for Impactful Individual rankImpactful Individual
4 years ago

Try creating it as a measure instead of a calculated column. That way you can reference columns in other tables. I'd use "SELECTEDVALUE()" for getting billing code. A simple example is the following screenshot (Product table and Country table are connected to Sales table):

 

 

  • alexa_0028's avatar
    alexa_0028
    Icon for Resolver II rankResolver II
    4 years ago

    Can someone please help me?