Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@T_JF2022 , refer if the blog or file can help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |