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, ...
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!

     

  • Benedict21's avatar
    Benedict21
    Frequent Visitor
    3 years ago

    I sent you a message with a link to the pbix. Thanks!