Hi Mynda
I've written a measure for calculating variance that references the budget table and the actual table: -
=SUM(Budget_table[Budget amount])-SUM(Actual_table[Amount Posted]) and this works fine.
Just out of interest, I tried to get the same result using a calculated column so, on the actual table, I inserted the same formula but I just ended up with the same numbers repeated. There is no relationship set up between these two fact tables (as per your recommendation on a previous tutorial) and wondered if this has got something to do with this.
Thanks for your help.
Tim
Hi Tim,
If you add a calculated column to calculate the variance in the actuals table then you'd need a relationship between the tables to support it, as you've found. However, this would not give you the correct results because not all budgeted items have an actual and vice versa. Simply, adding it as a column isn't the correct way to perform this calculation.
Mynda
Hi Mynda
Thanks for your response.
Tim
