Forum Discussion

Rohit001's avatar
Rohit001
Helper I
2 years ago

Forecast value

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)

 

"DAX"
"Power BI Report Server"
Forecasting

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.