Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Week over Week change %

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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/

 

 

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

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
Not applicable

Thank you very much for your help^^

 

 

 

Anonymous
Not applicable

@Anonymous 

 

it worked ?

Anonymous
Not applicable

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.

 

이미지 4.png

Anonymous
Not applicable

Hi @Anonymous ,

 

Try this for LastweekSales

LastWeekSales = 

Var ThisWeek = Max(WeekNum)

Return

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

 

Regards,

Gaurav

Anonymous
Not applicable

It worked perfect^^😊😊😊😊

 

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

 

Thank you, thank you...

 

Anonymous
Not applicable

@Anonymous 

 

 

Try this :

ThisWeekToDate = 

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

 

 

Anonymous
Not applicable

이미지 5.png

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.