cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoniaL Member
Member

week on week change

 Hi there!

 

I know this topic has been written about a lot, but I'm having trouble making it work. 

 

I have sales data by day, which I'd like to group by week and get the week - on - week % change. 

 

I have the data linked to a date table, and created a measure to get the P7D of sale 

 

Last 7 Days =
CALCULATE (
SUM ( 'Aladdin Updated Data'[Net Total Payment] ),
DATESINPERIOD ( 'Aladdin Updated Data'[SellDate], MAX ( 'Aladdin Updated Data'[SellDate] ), -7, DAY )
)

 

Now i just want to show the % change from the week previous. 

 

I thought maybe I could find the sales for days 14-7 and get the change from there? 

 

Haven't had any luck yet, hoping someone can help!

 

Thank yoU!

Sonia

3 REPLIES 3
Super User
Super User

Re: week on week change

Hey Sonia,

 

I'm wondering if you have given this site a closer look:

https://www.daxpatterns.com/time-patterns/

 

From my point of view, almost everything that can be said about time/date calculations is said.

 

If you do not find what you are looking for, please create a pbix with some sample data, upload the file to onedrive or dropbox and share the link.

 

Regards,

Tom 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Community Support Team
Community Support Team

Re: week on week change

Hi @SoniaL,

 

In addition, you could refer to this similar threads which has been solved.

 

https://community.powerbi.com/t5/Desktop/Week-over-Week-Comparison/td-p/298471

 

https://community.powerbi.com/t5/Desktop/Week-over-Week-Change/td-p/243318

 

If you still need help, please share some sample  data which could reproduce your scenario and your desired output so that we could help further on it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: week on week change

Hi @SoniaL,

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please share your data sample which could reproduce the scenario and your desired output so that we could help further on it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.