Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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 , 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
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
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |