Forum Discussion
Subtracting calculated columns from different data sets
That I have in the Visual Table, yes. FY16 - FY15 = The difference.
They are not averaged out in the data sets, they are per row. So they only get averaged out in the Visual Table, and that is what I want to see the difference of. And I can't figure out how to do it or know if it is even possible.
i don't understand where u struggeling .
Create new measure like
Measure = Sum(Value 2016) - Sum(Value2015)
and use it in visual,
If am not correct , let me know
I am getting the following error when utilizing that formula:
The SUM function only accepts a column reference as an argument.
I also tried SUMX(Values(FY16CPK)-SUMX(Values(FY15 CPK), but i get the error:
Too few arguments were passed to the SUMX function. The minimum argument count for the function is 2.
Cool my dear friend.
Try this. Create new measure or column whatever u want
Measure = CALCULATE(SUMX(Table Name ,SUM(Value2016) - SUM(Value2015)))
Let me know if it is not helping u
I was able to get it sorted out. I believe it was the CPK's in the data sets that were changed to an average which was messing everything up. I needed to nto use those, but create a measure for each data set, then create anew measure FY16 - FY15, which gave me the solution i needed.