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
guilhem
Frequent Visitor

forecasting and using the forecast

Hello,

 

My table is a list of issues. Those issues are can last from 1 to a few days. Some are predicted and some aren't.

My table is the list for each day (when there is a problem) of each issue with a planned/unplanned tag.

 

The table is as follow:

 

Issue number

Date 

Type (planned/unplanned)

 

Planned can be predicted therefore, there are issues with dates in the future. Unplanned aren't predictable, and therefore there aren't any dates in the futures for those. I would like to create futures issues myself. 

 

How could i do it automatically and have the result added to my table so I can actually forecast issues in the future ?

 

Hope this is clear 

 

Guilhem

 

1 ACCEPTED SOLUTION

yes sure ... here we are ... 

 

Issue#Date of IssueTypeQty
101/01/2016Planned10
102/01/2016Planned10
103/01/2016Planned10
104/01/2016Planned10
203/01/2016Unplanned5
306/02/2016Unplanned3
307/06/2016Unplanned3
307/10/2016Unplanned3
306/02/2017Unplanned3
308/06/2017Unplanned3
410/03/2016Planned5
411/03/2016Planned5
412/03/2016Planned5
413/03/2016Planned5
414/03/2016Planned5
415/03/2016Planned5
416/03/2016Planned5
417/03/2016Planned5
418/03/2016Planned5
419/03/2016Planned5
420/03/2016Planned5
421/03/2016Planned5
422/03/2016Planned5
423/03/2016Planned5

I would like to be able to add unplanned events with future dates to this table based on past unplanned only issues

View solution in original post

3 REPLIES 3
v-ljerr-msft
Employee
Employee

Hi @guilhem,

 

Could you post some sample data and the expected result in your scenario?Smiley Happy

 

Regards

yes sure ... here we are ... 

 

Issue#Date of IssueTypeQty
101/01/2016Planned10
102/01/2016Planned10
103/01/2016Planned10
104/01/2016Planned10
203/01/2016Unplanned5
306/02/2016Unplanned3
307/06/2016Unplanned3
307/10/2016Unplanned3
306/02/2017Unplanned3
308/06/2017Unplanned3
410/03/2016Planned5
411/03/2016Planned5
412/03/2016Planned5
413/03/2016Planned5
414/03/2016Planned5
415/03/2016Planned5
416/03/2016Planned5
417/03/2016Planned5
418/03/2016Planned5
419/03/2016Planned5
420/03/2016Planned5
421/03/2016Planned5
422/03/2016Planned5
423/03/2016Planned5

I would like to be able to add unplanned events with future dates to this table based on past unplanned only issues

Hi @guilhem,



I would like to be able to add unplanned events with future dates to this table based on past unplanned only issues

What do you mean about "add unplanned events with future date based on past unplanned only issues"? Could you be more precisely with your expected result?  Smiley Happy It is better to post your expected result within the sample table above.

 

Regards

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.