Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Fam,
I hope someone can help me.
I calculated our running total and plotted it as a line chart. The line chart gave us a pretty nice idea of how the business accelerated over the years. In line with that projection, is there a way for me to know how many months we lost in terms of growth?
The rolling total sales measure I used is:
Hi @Andrew_na_lang ,
How to use what-if function in power bi please refer this link.
Use what-if parameters to visualize variables - Power BI | Microsoft Docs
I think your first problem is how to calculate the trend line. Then subtract the current sales from the trend line. The trend line may be quadratic regression.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |