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!
Measure 2 = sum('table2'[volume])/Sum('table1'[Time])
Calculated column --> Time = (DATEDIFF('table1'[start time], 'table1'[end_time],SECOND))
Anonymous can you provide me with the outputs that you are seeing or provide example data please. Unfortunately, it's very challenging try to understand why a basic measure works as required in this instance but there are complications with the column.