Forcasting Dashboard weekly cumulative calculation with week period

[sinanalmac]

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 

 

[v-juanli-msft]

Hi @sinanalmac

Please refer to my pbix, i would explain later.

Best Regards

Maggie

[sinanalmac]

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

[sinanalmac]

Thank you  for  quick  respond @v-juanli-msft

I started to examine
Best Regards
Sinan 

[sinanalmac · Accepted 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 
 
the data example

[sinanalmac]

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