Forum Discussion
Solved
Dynamic Variance Based on Two Date Tables
Hi, I've spent some time in trying to develop a script that would allow me to create a dynamic variance calculation based on dates from two different tables. The code looks as follows: M_%_...
You will need to use ISFILTERED or ISCROSSFILTERED to figure out which of the date tables is filtered. What if they both are? Worst case you may have to use inactive relationships or disconnected tables.
