Previous week total

Anonymous — Tue, 18 Sep 2018 14:41:01 GMT

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.

Re: Previous week total

undergrinder — Tue, 18 Sep 2018 15:15:13 GMT

Hi Ism,

Try this expression:

=sum({$<week={'$(=max(week)-1)'}>} Value)

topic Previous week total in App Development

Previous week total

Re: Previous week total