Forum Discussion
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...
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,
In this scenario, you must have a Year column and a Week Number column in your table. To compare the current week and previous week. You can create a measure like below:
=
VAR CurrentWeekCountID =
CALCULATE (
COUNTA ( Table[ID] ),
ALLEXCEPT ( Table, Table[Year], Table[WeekNumber] )
)
VAR PreviousWeekCountID =
CALCULATE (
COUNTA ( Table[ID] ),
FILTER (
ALL ( Table ),
Table[Year] = MAX ( Table[Year] )
&& Table[WeekNumber]
= MAX ( Table[WeekNumber] ) - 1
),
ALLEXCEPT ( Table, Table[Year], Table[WeekNumber] )
)
RETURN
( CurrentWeekCountID - PreviousWeekCountID )
/ PreviousWeekCountID
If you still have any question, please share some sample data.
Regards,
should i make week based on year or day???
v-sihou-msft it doesnt work