topic Re: Week over Week change % in DAX Commands and Tips

Week over Week change %

Anonymous — Wed, 29 Jan 2020 04:38:02 GMT

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.

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 05:08:45 GMT

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/

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 05:34:46 GMT

Thank you very much for your help^^

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 05:36:06 GMT

Anonymous

it worked ?

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 05:44:59 GMT

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.

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 05:55:23 GMT

Hi Anonymous ,

Try this for LastweekSales

LastWeekSales =

Var ThisWeek = Max(WeekNum)

Return

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

Regards,

Gaurav

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 06:01:07 GMT

It worked perfect^^😊😊😊😊

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

Thank you, thank you...

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 06:03:21 GMT

Anonymous

Try this :

ThisWeekToDate =

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

Re: Week over Week change %

Anonymous — Wed, 29 Jan 2020 06:21:00 GMT