cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Forcasting Dashboard weekly cumulative calculation with week period

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)

week period.jpg
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 

 

 

data.png
 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Forecasting weekly cumulative calculate with period selection

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)

week period.jpg

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 
 
the data examplethe data example

  

View solution in original post

5 REPLIES 5
Highlighted
Helper III
Helper III

Forecasting weekly cumulative calculate with period selection

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)

week period.jpg

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 
 
the data examplethe data example

  

View solution in original post

Highlighted
Helper III
Helper III

Forcasting Dashboard weekly cumulative calculation with week period

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)

week period.jpg
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 

 

 

data.png
 

Highlighted
Community Support
Community Support

Re: Forcasting Dashboard weekly cumulative calculation with week period

Hi @sinanalmac

Please refer to my pbix, i would explain later.

 

Best Regards

Maggie

Highlighted
Helper III
Helper III

Re: Forcasting Dashboard weekly cumulative calculation with week period

Thank you  for  quick  respond @v-juanli-msft

I started to examine
Best Regards
Sinan 

Highlighted
Helper III
Helper III

Re: Forcasting Dashboard weekly cumulative calculation with week period

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 
week1 period 3 seneraio.jpg

 

Thank you

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors