topic Building a Line Chart With Forecast and Actual in One Line in DAX Commands and Tips

Building a Line Chart With Forecast and Actual in One Line

CuriousGuy001 — Fri, 14 Jun 2024 13:00:02 GMT

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!

Re: Building a Line Chart With Forecast and Actual in One Line

some_bih — Fri, 14 Jun 2024 16:15:06 GMT

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

Re: Building a Line Chart With Forecast and Actual in One Line

CuriousGuy001 — Fri, 14 Jun 2024 16:53:59 GMT

Hi,

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