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 yea...
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.