Forecast value

[Rohit001]

I am trying to find out the forecast alue for the next dates using balow formula but after applying the forecast value it not showi n the next date value it showing collection values 
dax code

Forecast 11 =

VAR CurrentMonth = MONTH(MAX('Table'[Date]))

VAR CurrentYear = YEAR(MAX('Table'[Date]))

VAR LastDateOfMonth = CALCULATE(MAX('Table'[Date]), ALL('Table'), 'Table'[Date] >= DATE(CurrentYear, CurrentMonth, 1), 'Table'[Date] <= EOMONTH(MAX('Table'[Date]), 0))

VAR RemainingDays = LastDateOfMonth - MAX('Table'[Date]) + 1

RETURN

IF(ISBLANK(SUM('Table'[Collection])), BLANK(), SUM('Table'[Collection]) * RemainingDays)

[Anonymous]

Hi, @Rohit001 

Based on the information you have provided, Here are my answers to your questions.

According to the DAX you provided and the data in the picture, I found that just a set of Collections to get a set of Forecast 11 is not enough, I don't really know your specific needs and how you want to present the effect picture at the end, if you can, you can give me one more set of Collections value or present a picture of the effect you want to realize.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dangar332]

hi, @Rohit001 

can you explain logic behind forcast value?