Actuals Running total till selected month and forecast after the selected month

[adnanarain]

Dear All,

I am trying to show running total of actuals till the selected month and forecast after the selected month in one line chart. Here is the file i am using:

Pbix file 

Thank you in advance for the help.

[amitchandak]

@adnanarain , Try a measure like

var _max = maxx(allselected('Date'),'Date'[Date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date]) && date[date] <=_max)) +
CALCULATE(SUM(forecast[forecast Amount]),filter(all(date),date[date] <=max(date[Date]) && date[date] >_max))

Common date table joined to you table and forecast and that is used on axis

[adnanarain]

@amitchandak  Thanks Amit,

I have already tried this but this is not working. I need a year and month slicer with single value selection and based on month selection. If you can please download the file and you will get clear idea

[v-jingzhang]

Hi @adnanarain 

Sorry I'm a little confused about the data table. In this table, there is a [Financial Date] column, [Month for Financial Date] and [Year for Financial Date]. Are the [Month for Financial Date] and [Year for Financial Date] columns identical with the [Fiscal Month] and [Fiscal Year] in DimDate table or are they just calendar month and year?

Do you look for a solution to get a similar output to the line chart in this blog?

Best Regards,
Community Support Team _ Jing

[adnanarain]

@v-jingzhang thanks for your reply. Financial month is the column to use. Ignore financial date

[v-jingzhang · Accepted solution]

Hi @adnanarain 

Is this what you want? Download the attachment to see details. I add a Financial Month column in DimDate table and four new measures. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[adnanarain]

@v-jingzhang Thank you so much.