Forum Discussion

TotalAnonymous's avatar
TotalAnonymous
Helper III
2 years ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    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's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

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