Forum Discussion
Create Calculated Column by dividing columns from two different TABLES
I want to create a calculated column by dividing columns from 2 tables linked with each other. It is giving me wrong answer. How to do this. Thanks in advance!
Hi Anonymous
Can you try this:
Column =
VAR _1 = SUM ( Table1[Amount] )
VAR _2 = SUM ( Table2[Amount] )
VAR _3 = _1 / _2
RETURN
IF ( _3 = 0 , 0 , _3 )
Hope this helps.
Theo