Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to create a measure that will, based on whatever date, retrieve the prior weeks total. Basically table should look like following:
Date Week Value
9/15 1 Week 0 Total
9/16 1 Week 0 Total
9/17 2 Week 1 Total
9/18 2 Week 1 Total... so on...
I am aware that week numbers are incorrect, just trying to provide an example of what I am trying to create. I have an expression, but it does not correctly display data, rather weeks are rolling.
Any help is appreciated, thanks in advance for any help.
Hi Ism,
Try this expression:
=sum({$<week={'$(=max(week)-1)'}>} Value)
G.