Calculate weekly total

[Anonymous]

Hi Experts,

Could you pls help me with this?

I am trying to derive a solution based on weekly data mentioned below;

DATE	Sales
1/02/2020	32
1/02/2020	45
2/02/2020	25
3/02/2020	36
4/02/2020	6
5/02/2020	52
6/02/2020	45
7/02/2020	52
8/02/2020	85
9/02/2020	96
10/02/2020	65
11/02/2020	85
12/02/2020	25

Trying to apply dax, but unable to get the correct answer.

Would appreciate your help and assistance in this regard

thanks

[amitchandak]

@Anonymous , Not very clear. For Week on Week analysis, refer my blog

Power BI — Week on Week and WTD
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

[Anonymous · Accepted solution]

Hello Amit,

Thanks for sharing the link where it shows all possible way to get the calcualtion right.

I was able to derive correct results.

Sorry for not very clear with my question.

I shall try to provide more info in my next query if any.

Regards

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490