Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using Previous Month Value for Future

I'm having difficulty creating a new column that uses the previous month's Forecast Percentage for future months. I'm using the measure below but it's just showing blanks for August onwards. DAU Me...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago
Firstly, if your Dates table is marked as date table you don't need the .[Date] portion of that calculation, so can be:

DAU Measure 3 = CALCULATE([Average Users (actuals)],PREVIOUSMONTH(Dates[Date]))

What is the formula for [Average Users (actuals)] and can you confirm the months you are using are from the Dates table? Do you also have a year filter on this page or visual? Otherwise you might be getting unexpected results.

If your Dates table or any filters in the report are configured to stop at today or this month, that could be the source of your problem.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, Allison. The year is filtered on 2020 but I doubt that is the issue because I need to have the previous month values to be carried into the remainder of 2020. Here are the other measures:

     

    Average Users (actuals) = CALCULATE(DIVIDE([DAU 1M MA],[Total Devices Base - Actuals]))

     

    DAU 1M MA =
    IF ( MAX ( ‘Dates’[Date] ) <= TODAY (),AVERAGEX(
    DATESINPERIOD( Dates[Date],
    LASTDATE( Dates[Date] ),
    -1, MONTH ),
    [Total Users2] ), [DAU Target])

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      We really need your sample data to figure it out.

       

      Thanks for your understanding and support.

       

      Best Regards,

      Dedmon Dai