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