Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm having a bit of a struggle with this.
I have one data set that contains productID and product unit price and another data set that contains productID and unit cost. I have them related so that I can see the product ID, unit price and unit cost in the report, but I want to create another (measured?) column for unit profit. this is what I'm trying:
Measure = SUM(ALLdata[Unit Price]-('display-cost-feb2016'[Cost]))
But it tells me the SUM function only accepts a column reference as an argument. Unit Price and Cost are both column names, just on 2 different data sets. What am I doing wrong?
thanks!
Solved! Go to Solution.
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.