Forum Discussion
qwaiti27231
Helper III
Helper IIIweek 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...
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,
qwaiti27231Helper III
Helper IIIshould i make week based on year or day???
qwaiti27231Helper III
Helper IIIv-sihou-msft it doesnt work
v-sihou-msftMicrosoft Employee
- qwaiti27231
- v-sihou-msft
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,