Forum Discussion

Helper III

8 years ago

Solved

week on week

i need the dax formula for week on week for eg count of order Id with 10/9/2017- count of order with 3/9/2017)/count Of order in 3/9/2017 For eg count of order at 3/9/2017= 32 count of or...

Need Help

v-sihou-msft
8 years ago
qwaiti27231

You can create a measure like below:

7 days ago value = CALCULATE(SUM(Table5[Value]),FILTER(ALL(Table5),Table5[Date]=MAX(Table5[Date])-7))

Regards,