Forecasting Current College Term Data

[stealth_66]

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.

[Anonymous]

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.

[stealth_66]

Hi Liu,

I am not sure what some of the values are returning.  What is [qu]?  Here is a copy of my pbix.  https://app.powerbi.com/groups/7dd5ba50-5dc0-485b-86fb-e35a83efbc57/reports/d95d3789-7193-43b1-bc6a-...