Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.