Forum Discussion
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...
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])
Hi Anonymous ,
We really need your sample data to figure it out.
Thanks for your understanding and support.
Best Regards,
Dedmon Dai