Forum Discussion

vandavarosi's avatar
vandavarosi
Regular Visitor
3 years ago

Continuous forecast calculation

Hi,    I would like to calculate the next year forecast in my power BI model based on the currectly available data.    Calculation method should be: 3MO AVERAGE forecast * growth date; however, t...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi vandavarosi ,

Please have a try.

Create measures.

Measure =
VAR _1 =
    MAXX ( ALL ( 'Table' ), 'Table'[Date] )
VAR _2 =
    EDATE ( _1, -3 )
RETURN
    AVERAGEX (
        FILTER ( ALL ( table ), table[date] <= _1 && table[date] >= _2 ),
        table[3MO]
    )

How to Get Your Question Answered Quickly 

 

If it still does not help,Please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

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