Forum Discussion

Frequent Visitor

5 years ago

Solved

Roolling previous weeks

Hi team, Best way to calculate "sales" for current Week, Last week, -2 weeks...and so on? Considering weeks starts on Monday. I have read many about, but withouth a clear idea of how to do. ...

Need Help

amitchandak
5 years ago
ADRICHECKIN , Using week rank in Date table, You can try.

Refer my Power BI — Week on Week and WTD blog and video
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

amitchandak

Super User

5 years ago

ADRICHECKIN , Using week rank in Date table, You can try.

Refer my Power BI — Week on Week and WTD blog and video
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

ADRICHECKIN

Frequent Visitor

5 years ago

Thank you very much. Easy, simple and work perfectly!

Forum Discussion

Roolling previous weeks

Related content

Calculate previous week total and previous 2 weeks total

Previous Week DAX

Calculate previous week values

Previous Week Sales

Count current week and previous week