Shift Date by a number of days

[Iamnvt]

hi,

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?

Thanks

[v-chuncz-msft]

@Iamnvt,

To shift either forward or backward in time by the specified number of intervals from the dates, you may take a look at DATEADD Function.

[MattAllington · Accepted solution]

try this

calculate(A, filter(Date table, Date = lastdate(Date) -3))