Forum Discussion
Create a Calculated Column from Different Data sets
Your syntax has to be changed to
Measure = sum(Table1[column1]) - sum(Table2[column2])
Can you try this and let me know if it is ok?
Your syntax has to be changed to
Measure = sum(Table1[column1]) - sum(Table2[column2])
Can you try this and let me know if it is ok?
I'm trying to do something similar to this but I'm calculating a share percentage so I'm dividing the two numbers (ex. sum(Table1[column1]) / sum(Table2[column2]). The problem I'm having is that the value from table 2 seems to have lost any reference it had to the year because my numbers are way off because it is using the grand total of the column 2 value for the division instead of just using the portion that belongs to a single year (see below).
The _ITAVolume number for 2011 should be around 158,000.
Any assistance with this would be greatly appreciated.