Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Thank you in advance for the help.
Solved! Go to 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 , 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
@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
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
@v-jingzhang thanks for your reply. Financial month is the column to use. Ignore financial date
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |