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 ,
From this:
Only measure is giving the correct value and not the calculated column.
I have put the slicer of Start Time on the report based on which it will calculate max speed.
It seems that the max speed is dynamiclly based on the selected date period in slicer, right?
If so, calculated column is not available since it is static and could not be changed. You have to use measure instead.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.