Forum Discussion

Gajo's avatar
Gajo
Helper I
8 years ago

Using linked data in calculated columns

I have two tables: one with Product data and one with specifications. In the table with product data I have created two extra columns with the Lower and Upper Spec from the spec file with the limits...
Need Help
Tips and Tricks
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Gajo,

 

Is there any relationship between the two tables? Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue?

 

In addition, could you try using the formula below to create a new measure to see if it works in your scenario? :smileyhappy:

NormalizedValue =
CALCULATE ( SUM ( '1 0 VerOutput'[Value] ) )
    - CALCULATE ( SUM ( '1 0 SpecOutput'[USL] ) )

 

Regards