How to show actual and forecast in one matrix

[Pbiuserr]

Hello,

I've prepared visually what I want to represent, horizontal way to not it let be too long. Basically what I want to do is to bring "Actual" values up until the user selection (in the example Jun-2022) and fill rest of the dates until current month with forecast. I have standard data model - dim table with dates (month year as the slicer) and  the actual and forecast is stored in fact table as "expenses" with assigned property either "actual" or "forecast" they're calculated as measure the way CALCULATE ( SUM ( facttable[Expenses], EXP_TYPE = "actual" (or "forecast) ). Is it something I can achieve? I know it will be in two separate columns

[amitchandak · Accepted solution]

@Pbiuserr , make sure the slicer filter is coming from an independent date tbale. Then have meausre like

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return

if(max(Date[Date]) <=_max, [Actual], [Forecast])