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
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.
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