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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
TotalAnonymous
Frequent Visitor

Previous Week DAX

Hello everyone, hope you're doing well.

I have an issue regarding Previous Week calculation using DAX. I have sales table that is represented in the weekly basis. How can I calculate the Previous Week Sales since it's more challenging using Standard Date Table?
The purpose of why I want to calculate the previous week is to be a baseline to calculate Current Week vs Previous Week Sales, Current Week vs Same Week in the last month.


Please kindly find the attached link into the PBIX file. Really appreciate your help and support. Thank You!

Link to PBIX: https://drive.google.com/file/d/1p8O6ntoT_A02JGjdV-nTcK8hD0BK3HJ6/view?usp=sharing

1 ACCEPTED SOLUTION

Hi,

Not sure what you want the answer to be but i get 6000 with this edited measure

Total Sales Last Week = CALCULATE([Total Sales],DATESBETWEEN('Calendar'[Date],MAX('Calendar'[Date])-6,MAX('Calendar'[Date])))

Hope this helps.

Ashish_Mathur_0-1713327917556.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
TotalAnonymous
Frequent Visitor

Hi Ashish, Thanks for replying! The questions are:
1) How to show the value of last week? since in the PBIX file, specifically in the Card Visual, the previous week sales is a cumulative of previous week in March
2) How can I calculate the Current Week vs Same Week in the Last Month?

Thank you!

Hi,

Not sure what you want the answer to be but i get 6000 with this edited measure

Total Sales Last Week = CALCULATE([Total Sales],DATESBETWEEN('Calendar'[Date],MAX('Calendar'[Date])-6,MAX('Calendar'[Date])))

Hope this helps.

Ashish_Mathur_0-1713327917556.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ashish, thanks for your reply! Let me try and back to you as soon as possible. Thank you

Ashish_Mathur
Super User
Super User

Hi,

What problem are you facing there?  You have already writtten the formula.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.