Week over Week change %

[Anonymous]

Hello,

I need to calculate Week over Week change %. 

i write the following DAX but red highlighted one has Error.

How should  i change the expression?

Week change =

VAR lastweekamount =

CALCULATE(

SUM(Power_BI_Book_Coin[R_Coin_Cnt]),

FILTER(

ALL(Power_BI_Book_Coin),

RELATED('Date'[WeekYear]

= MIN('Date'[WeekYear]-1))

)

)

RETURN

IF(lastweekamount = 0, "N/A",

DIVIDE(SUM(Power_BI_Book_Coin[R_Coin_Cnt]) - lastweekamount, lastweekamount, 0)

)

 Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please use the below formula 

Measure =
VAR lastWeekAmount =
    CALCULATE (
        SUM ( Value Sum),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[WeekNum]
                = MIN ( 'Calendar'[WeekNum] ) - 1
        )
    )
RETURN
    DIVIDE ( SUM ( Value Sum ) - lastWeekAmount, lastWeekAmount, 0 )

Regards,

Gaurav  Raj Singh

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/

[Anonymous]

Thank you very much for your help^^

[Anonymous]

@Anonymous 

it worked ?

[Anonymous]

Yes it worked^^ Thanks you

By the way, i need to show Week sales as following

In this case i need to calculate This week sale and last week sale.

would you help me Dax for those?

Thank you very much again.

[Anonymous]

Hi @Anonymous ,

Try this for LastweekSales

LastWeekSales = 

Var ThisWeek = Max(WeekNum)

Return

calculate(sum(sales),WeekNum = ThisWeek - 1)

Regards,

Gaurav

[Anonymous]

It worked perfect^^😊😊😊😊

How about week to date /This week sale/??

Thank you, thank you...

[Anonymous]

@Anonymous 

Try this :

ThisWeekToDate = 

calculate(sum(sales),WeekNum = MAX(WeekNum))

[Anonymous]