Forum Discussion
Subtracting calculated columns from different data sets
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.
Hi Stymied9,
Glad to hear the issue is solved, you can accept helpful replies as solution, that way, other community members will easily find the solution when they get same issue.
Thanks,
Lydia Zhang
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.