Forum Discussion

Benedict21's avatar
Benedict21
Frequent Visitor
3 years ago

DAX repeating values

Hello,    I am creating a forecast by averaging the previous 6 months data. I can get those values no problem. However, I want to repeat next month's forecast for the upcoming months. For example, ...
amitchandak's avatar
amitchandak
Super User
3 years ago

Benedict21 , Try a measure like using Incidents Forecast measure

 

calculate(lastnonblankvalues(Date[Date], [Incidents Forecast]), filter(all(Date), Date[Date] <= max(date[Date]) )

  • Benedict21's avatar
    Benedict21
    Frequent Visitor
    3 years ago

    Hi, 

     

    Thank you, but the results are 0s and 1s.

    • Benedict21's avatar
      Benedict21
      Frequent Visitor
      3 years ago

      I tried using this measure; however, it is not providing the correct result.

       

      Test = 
      CALCULATE(

      LASTNOTBLANKVALUE('Dates'[Date], [Incidents Forecast]), FILTER(ALL('Dates'[Date], [Date] <=MAX('Dates'[Date])))

      • amitchandak's avatar
        amitchandak
        Super User
        3 years ago

        Benedict21 ,
        Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.