Using Previous Month Value for Future

[Anonymous]

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 Measure 3 = CALCULATE([Average Users (actuals)],PREVIOUSMONTH(Dates[Date].[Date]))

[v-deddai1-msft]

Hi @Anonymous ,

Would you please inform us more detailed information( your  pbix file (by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[AllisonKennedy]

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]

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]

Hi @Anonymous ,

We really need your sample data to figure it out.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai