Forum Discussion

T_JF2022's avatar
T_JF2022
Frequent Visitor
4 years ago
Solved

Year table with columns from different tables

I have created a forecast based on open orders and closed orders for the entire business year.
The sales are broken down by month (i.e. jan, feb, march etc).
I would like to replace the calculated values of the future months with a projection. (replace column april with the values of the projection)

 

But I don't know how to replace the values so that the expected sales for the year 2022 is reached.

 

 

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi T_JF2022 ,

    According to your description, I create a sample.

    Here's my solution.

    Assuming that forecast is the average of the previous values.

    Forecast = AVERAGEX(ALL('Table'),'Table'[Sales])

    Create a measure.

    Sales' =
IF (
    MAX ( 'Table'[Sales] ) <> BLANK (),
    MAX ( 'Table'[Sales] ),
    'Table'[Forecast]
)

    Get the result.

    I attach the sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

2 Replies