Building a Line Chart With Forecast and Actual in One Line

[CuriousGuy001]

Hi everyone,

I am currently building a line chart with forecast and actual in one line. I am stuck in one problem where the "Actual and Forecast" column doesn't display the revenue forecast for the month of June, in the actual revenue I do have few data for June but it is filter out with a measure. 

This is the DAX measure,

Actual and Forecast =

    VAR LastSalesDate =

        CALCULATE(

            MAX(SalesTeam_YTD[Actual Appointment Date]),

            REMOVEFILTERS()

)

    VAR Actual = [Actual Revenue]

    VAR Forecast =

CALCULATE(

    [Forecast Revenue],

    Filter(

        'Forecast_Plan_2024',

        'Forecast_Plan_2024'[Year 2024]>LastSalesDate

    )

)

VAR Result = Forecast + Actual

RETURN  

Result

I would appreciate if anyone can help me, thank you!

[some_bih]

Hi @CuriousGuy001 without your model, it is hard to provide solution for your case.

Still, check example about showing actual and forecast data on link

[CuriousGuy001 · Accepted solution]

Hi,

Thank you! I solved it by adding few June's data and now it is working!