Forum Discussion
Solved
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 ...
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.
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.
Hi Ashish, thanks for your reply! Let me try and back to you as soon as possible. Thank you