Add back Forecast into running total of the Actuals Value is blank

[WhaleWatcher222]

Hi Expert

See sample data image below...

from the above image the running total works up to Feb 25 - here is the challenge where the Actual data point for Mar 25 is blank i want to add back the forecast Value - So Mar 25 should be 147,183 + 8,948

Measure 1. (new forecast is the forecast column in the image)

New Forecasts = IF(ISBLANK([Total Actuals]),[Total Selected Forecasts],[Total Actuals])

Measure 2.

New Forecasts running total in Date = 
CALCULATE(
        [New Forecasts],
            FILTER(
                ALLSELECTED('Date'[Date]),
            'Date'[Date] <= MAX('Date'[Date])
        )
)   

[Anonymous · Accepted solution]

Hi,@WhaleWatcher222 .I am glad to help you.

If you are trying to show the modified cumulative result in table visual, you can refer to my test below

Assuming that the values in the screenshot you provided are real column data (not measures)

My test data:

NewForecastsunningtotal = 
VAR _date =
    MAX ( 'TestTable'[Period] )
VAR _NewForecastsunningtotal =
    CALCULATE (
        SUM ( 'TestTable'[Actuals] ),
        FILTER ( ALLSELECTED ( 'TestTable' ), 'TestTable'[Period] <= _date )
    )
RETURN
    _NewForecastsunningtotal



Result = 
VAR _actuals = MAX('TestTable'[Actuals])
VAR _forecasts =MAX('TestTable'[Forecasts])
RETURN
IF(ISBLANK(_actuals),[NewForecastsunningtotal]+_forecasts,[NewForecastsunningtotal])

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WhaleWatcher222]

Hi Carson - can you she some light on the following since you solved the above and the question is linkedin - no one on the community can solved it.

https://community.fabric.microsoft.com/t5/Desktop/Forecast-FY-is-incorrect-based-on-the-measures-use...

[WhaleWatcher222]

Hi Carson - They are measures created from a single column in  the FACT Table  - Apologies. and firstly many thanks for the feedback much appericated