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, All I have a problem with a forecasting dashboard in power BI desktop. I use Power BI Desktop RS (March 2018).
I need to calculate cumulative Accuracy with the selected week and in selected period
the periods are
1,2,3,4,8,13 ( weeks)
For example
if I Select week 2 and period 3 I need to calculate 2,3,4 weeks cumulative accuracy
if I select week 2 and period 4 I need to calculate 2,3,4,5 week cumulative accuracy
if I select week 4 and period 4 I need to calculate 4,5,6,7 week cumulative accuracy
if I select week4 and 5 together and period 4 I need to calculate 4 and 5 total. for week4 calculate 4,5,6,7 cumulative and week 5 calculate 5,6,7,8 cumulative
Any suggestions
I'm sharing example data
Thank you and best regards
Sorry my bad English
Solved! Go to Solution.
Hi, All I have a problem with a forecasting dashboard in power BI desktop. I use Power BI Desktop RS (March 2018).
I need to calculate cumulative Accuracy with the selected week and in the selected period
the periods are
1,2,3,4,8,13 ( weeks)
For example
if I Select week 2 and period 3 I need to calculate 2,3,4 weeks cumulative accuracy
if I select week 2 and period 4 I need to calculate 2,3,4,5 week cumulative accuracy
if I select week 4 and period 4 I need to calculate 4,5,6,7 week cumulative accuracy
if I select week4 and 5 together and period 4 I need to calculate 4 and 5 total. for week4 calculate 4,5,6,7 cumulative and week 5 calculate 5,6,7,8 cumulative
Any suggestions
I'm sharing example data
Thank you and best regards
Sorry my bad English
Hi @v-juanli-msft(Maggie),
I examined your Pbix file.
I have something that I couldn't understand.
What is your logic to calculate this?
I want to tell you something about the Accuracy and difference calculation
Add colum
Difference = ABS([ Forecast ]-[Sales])
Measure
Accuracy = (1- SUM([Difference])/SUM([Sales]) )
I'm sharing with you the calculate which I'm trying to reach.
Senaro 1 : period 3 () and Week 1,2,3. selected the same time
Thank you
Thank you for quick respond @v-juanli-msft
I started to examine
Best Regards
Sinan
Hi, All I have a problem with a forecasting dashboard in power BI desktop. I use Power BI Desktop RS (March 2018).
I need to calculate cumulative Accuracy with the selected week and in the selected period
the periods are
1,2,3,4,8,13 ( weeks)
For example
if I Select week 2 and period 3 I need to calculate 2,3,4 weeks cumulative accuracy
if I select week 2 and period 4 I need to calculate 2,3,4,5 week cumulative accuracy
if I select week 4 and period 4 I need to calculate 4,5,6,7 week cumulative accuracy
if I select week4 and 5 together and period 4 I need to calculate 4 and 5 total. for week4 calculate 4,5,6,7 cumulative and week 5 calculate 5,6,7,8 cumulative
Any suggestions
I'm sharing example data
Thank you and best regards
Sorry my bad English
Hi, All I have a problem with a forecasting dashboard in power BI desktop. I use Power BI Desktop RS (March 2018).
I need to calculate cumulative Accuracy with the selected week and in selected period
the periods are
1,2,3,4,8,13 ( weeks)
For example
if I Select week 2 and period 3 I need to calculate 2,3,4 weeks cumulative accuracy
if I select week 2 and period 4 I need to calculate 2,3,4,5 week cumulative accuracy
if I select week 4 and period 4 I need to calculate 4,5,6,7 week cumulative accuracy
if I select week4 and 5 together and period 4 I need to calculate 4 and 5 total. for week4 calculate 4,5,6,7 cumulative and week 5 calculate 5,6,7,8 cumulative
Any suggestions
I'm sharing example data
Thank you and best regards
Sorry my bad English
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |