Year table with columns from different tables

[T_JF2022]

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.

[v-yanjiang-msft · Accepted solution]

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.

[amitchandak]

@T_JF2022 , refer if the blog or file can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...