Forum Discussion
Helper IIHow to Calculate Expected Volume...Forecast?
Hi All,
I'm looking to calculate the expected volume of incoming interviews over a rolling 14-day period. It's been decades since high school statistics class, so this one might be pretty general. My intution is that it's possible to do in Power BI, but I'm not sure how to go about it. I have a table with information on interviews our researchers conduct. The interviews table is connected to a projects table. Here's a sample of data from the interviews table:
| Date Created | Related Project | Project Interview # | Interview Status | Interview Length (min) | Project Day |
| 1/1/21 | Project A | 1 | Sent | 30 | 8 |
| 1/1/21 | Project B | 1 | Sent | 45 | 12 |
| 1/1/21 | Project A | 2 | Assigned | 25 | 8 |
| 1/2/21 | Project B | 2 | Assigned | 60 | 13 |
Here's a sample of the data in the projects table:
| Date Created | Name | Interviews Sent | Interview Goal | Interviews Logged | Target End Date | Status | Complete Date |
| 12/25/20 | Project A | 1 | 5 | 2 | 1/14/21 | In Progress | |
| 12/21/20 | Project B | 1 | 10 | 2 | 1/12/21 | In Progress | |
| 1/1/21 | Project C | 0 | 8 | 0 | 1/21/21 | In Progress |
With the data I have, what I want to know is when I can expect interviews from Project C to start coming in, and when will the rest from projects A & B come in? Can I do this in Power BI? A measure that takes into account the most popular Project Day from the interviews table, the average project length from the projects table? Should I be approaching this in another way? I want to know this info beforehand because once interviews are logged there are various production stages that occur before they're marked finished. It would give us great insight into when there might be staffing bottlenecks, among other things. Thoughts?
Thanks,
Daniel
1 Reply
v-deddai1-msftCommunity Support
Hi danielgajohnson ,
Would you please show us your expected output based on the sample data? I can't tell you if the reuqirement can be achieved in power bi since I didn't understand your logic of expected output. please give an example with explanation.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai