cancel
Showing results 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

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

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

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.

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

Announcements

#### 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.

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

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

Top Solution Authors
Top Kudoed Authors