Forum Discussion

stealth_66's avatar
stealth_66
Frequent Visitor
4 years ago

Forecasting Current College Term Data

Hi folks.  I am new to Power BI and I have been struggling for a few weeks trying to figure out how to do the forecasting in Power BI.  This is a sample of my data:  

This data goes back 6 years with current data for Summer and Fall.  Data is collected for types of app=applications received and types of enr=enrollments weekly.  I only need the forecast for the summer (1222) and fall (1223) terms.  I have data up through 4/3/2022 report date.  I need to forecast the summer term through 6/19/2022 (start date of 1/30/2022) and fall term through 9/4/2022 with same start date.  I have a current visual that compares the data against years and at same time frame in term.  But I want to have the comparison along with the forecast (except the actual values) when there are some actual values.

I have no idea on just how to set up the forecast. Any help is greatly appreciated.

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  stealth_66 ,

    You might consider adding a Y-Axis Constant Line to Analytics.

    Create a measure by customizing the rules and place it in to form a prediction line

    Or you can consider creating a calendar table. Create measure through custom rules, use the calendar table's Days Before Start as the Axis, and the Measure as the Value.

    Create calculated table.

    Table 2 =
CALENDAR(DATE(2022,1,7),DATE(2022,12,31))

    Create measure.

    Measure 2 =
var _select=SELECTEDVALUE('Table'[Unit Type])
return
SWITCH(
    TRUE(),
    MAX('Table 2'[qu])<MAX('Table'[qu]),CALCULATE(SUM('Table'[Unit Value]),FILTER(ALL('Table'),'Table'[qu]=MAX('Table 2'[qu])&&'Table'[Unit Type]=_select)) + 1000,
     MAX('Table 2'[qu])=MAX('Table'[qu]),CALCULATE(SUM('Table'[Unit Value]),FILTER(ALL('Table'),'Table'[qu]=MAX('Table 2'[qu])&&'Table'[Unit Type]=_select)) ,
     CALCULATE(SUM('Table'[Unit Value]),FILTER(ALL('Table'),'Table'[qu]=MAX('Table 2'[qu])&&'Table'[Unit Type]=_select)) + 2000)

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.