week on week

[qwaiti27231]

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 order in 10/9/2017 =52

((52-32)/32)*100=62.50%

[v-sihou-msft]

@qwaiti27231

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,

[qwaiti27231]

should i make week based on year or day???

[qwaiti27231]

@v-sihou-msft it doesnt work

[v-sihou-msft]

@qwaiti27231

Can you share some sample data?

[qwaiti27231]

@v-sihou-msft 

[v-sihou-msft · Accepted solution]

@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,

[qwaiti27231]

@v-sihou-msft is there any way i can contact  you...Requesting  ur help in many other queries....just joined as BI developer..would appreciate ur help

[qwaiti27231]

please mention count of order ID in dax formula