10-19-2017 09:30 PM
this has a simple problem; however, my mind is wandering around and couldn't find a solution for that.
I have a measure A = sum(Values) by date
and I want to calculate measure B = Measure A shifted 3 days earlier.
tried: calculate(A, filter(Date table, Date = Date -3)), but it doesn't work.
any helps pls?
Solved! Go to Solution.
10-22-2017 11:36 PM