Forum Discussion
How to subtract values from the same column
Hello all, I am currently trying to create a parameter that shows a week over week difference. I have a slicer up to based on weeks and a table below with values for each week. I would like to s...
Hi sv98917n
I have a test by my sample, but your calculated column works well.
Calculated column:
diff =
Tons[Value]
- CALCULATE (
SUM ( Tons[Value] ),
FILTER ( Tons, Tons[Calendar Week Num] = EARLIER ( Tons[Calendar Week Num] ) - 1 )
)My Sample:
If your table is like mine, your calculated column is correct.
I think your issue may cause by your data model.
Could you show me your sample by a screenshot or share your pbix with me by your Onedrive for Business?
This may make it easier for me to solve your problem.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.