How to create a monthly Forecast label with sum on the Power BI report?

[Rck7]

Hi folks,

I have a table with a column for the dates with data from (27-Oct-14 to 26-Oct-17).  I have created a custom column chart with Monthly Data for the Fiscal year(Oct- september) and an Estimated constant value of "75000/Month". 

I am trying to create a label similar to the others(Previous Month Total, Earliest Update On, etc.) that shows the sum of estimated values for any selected dates on a monthly basis (i.e. 75000+ 75000+ 75000). 

The problem, is that 75000/month is a manual entered value specified as a constant line in the graph and I want to show the sum of my monthly estimates for the selected dates in a  label below the chart. How would I be able to do that?

Here is my chart:

  

Any help would be appreciated!!!!
Thank you.

[v-jiascu-msft]

Hi @Rck7,

Maybe you can use a measure instead of the constant line. 

Constant = 75000

How do you want to select the dates? Months or Days? Continuous or discontinuous? Maybe you can try this formula.

Measure = count('Date'[Date].[Month]) * [Constant]

Best Regards!

Dale

[Rck7]

@v-jiascu-msft. I have the daily data of all the months, for the years mentioned in the original post in my data column. 

What I would like to see in my published file is, the rolling totals of the constants from (octomeber 2016- the upcoming months). 

I have the actual running totals value(sum) available as u see in the picture below and what I wanted to see is the sum of my constant values(i.e. 75000+ 75000+...) for the same dates i am fetching the running totals and yes it should be continous. So that, I can find the difference between the sum of (running totals vs estimated totals). 

Here is my data looks like:



Kindly, help.
Thank you. 

[v-jiascu-msft · Accepted solution]

Hi @Rck7,

You can use the formula below to get the number of months. Then multiplying 75000 is the result of forecast.

Resul =
COUNTROWS (
    SUMMARIZE ( Sales, Sales[Order Date].[Year], Sales[Order Date].[Month] )
)
    * 75000

Or, 

Resul =
COUNTROWS (
    SUMMARIZE ( Sales, Sales[Order Date].[Year], Sales[Order Date].[Month] )
)
    * [Constant]

 Please vote this idea or create a new one. 

Best Regards!

Dale