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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors