Forum Discussion
Calculate weekly total
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
- Anonymous5 years ago
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
3 Replies
- amitchandakSuper User
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- AnonymousNot applicable
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