Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sinanalmac
Resolver I
Resolver I

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
sinanalmac
Resolver I
Resolver I

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
v-juanli-msft
Community Support
Community Support

Hi @sinanalmac

Please refer to my pbix, i would explain later.

 

Best Regards

Maggie

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

Thank you  for  quick  respond @v-juanli-msft

I started to examine
Best Regards
Sinan 

sinanalmac
Resolver I
Resolver I

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

  

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
 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.