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.

      • Benedict21's avatar
        Benedict21
        Frequent Visitor
        3 years ago

        Hi! Thank you so so much for your help! I recreated the file with test data. I have 5 columns:
        Date

        Count of Incidents

        Count Incidents Sum (measure)
        Count Incidents rolling average (measure)

        Cumulative Forecast (measure)

        I want to repeat the forecasted value for the next month (9 in this case), and not continue the rolling average. So Jan 2023, Feb 2023, Mar 2023, etc., should all equal 9.

         

        Thank you again for your help!