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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors