Measure to combine Actual and Forecast

[Eureka]

Hello,

I have a use case where i have a table with Forecast data, another table with actual data. 

I want to create a measure that will combine the forecast and the actual in the same measure.

For month before the forecast date the idea is to take the actuals and for the months after the forecast date the idea is to take the forecast data.

Actuals	Forecast	Date	Forecast date	New measure
40		janv-23	avr-23	40
56		févr-23	avr-23	56
68		mars-23	avr-23	68
53	51	avr-23	avr-23	51
48	44	mai-23	avr-23	44
56	67	juin-23	avr-23	67
56	60	juil-23	avr-23	60
52	70	août-23	avr-23	70
48	65	sept-23	avr-23	65
51	61	oct-23	avr-23	61
	47	nov-23	avr-23	47
	38	déc-23	avr-23	38

How can I achieve this?

Thank you 

[Eureka · Accepted solution]

I tried this: 

New measure = sumx(VALUES('Time'[Date]), if(ISBLANK(Forecast), Actuals, BLANK())) + Forecast

It seems to work

[sanalytics]

Hello @Eureka 

Based on your data please try below measure

New Measure =

SUMX(

     'Table',

     IF(

         ISBLANK( 'Table'[Actuals] ),

         'Table'[Forecast],

    IF(

         ISBLANK( 'Table'[Forecast] ),

         'Table'[Actuals],

    IF(

        'Table'[Actuals] <> BLANK() &&

        'Table'[Forecast] <> BLANK(),

        'Table'[Forecast]

    )

    ) ) )

Hope it will help you,

Regards

sanalytics

If it is your solution then please like and accept it as solution

[Eureka]

So far  I have tested that: 

New measure = 

f( ISBLANK(CALCULATE(SUMX(values(Date),Forecast))), Actuals, Forecast)

It's working when I show the date in the table when I remove it is getting me only forecast data.