Lookup previous month value

griffinst 

pls try this

Column = MAXX(FILTER('Table','Table'[Project]=EARLIER('Table'[Project])&&'Table'[FCST Date]=EDATE(EARLIER('Table'[FCST Date]),-1)),'Table'[FCST])

 

Column 2 =

VAR _status=MAXX(FILTER('Table','Table'[Project]=EARLIER('Table'[Project])&&'Table'[FCST Date]=EDATE(EARLIER('Table'[FCST Date]),-1)),'Table'[Status])

return if(_status="","",if(_status='Table'[Status],"F","T"))

 

Hi griffinst 

Maybe you can try this:

Here I create 2 calculated columns:

_Prior Month =
CALCULATE (
    SUM ( 'Table'[FCST] ),
    ALLSELECTED ( 'Table' ),
    'Table'[Project] = EARLIER ( 'Table'[Project] ),
    DATEADD ( 'Table'[FCST Date], -1, MONTH )
)

_Status Change? =
VAR _priorStatus =
    CALCULATE (
        SELECTEDVALUE ( 'Table'[Status] ),
        ALLSELECTED ( 'Table' ),
        'Table'[Project] = EARLIER ( 'Table'[Project] ),
        DATEADD ( 'Table'[FCST Date], -1, MONTH )
    )
RETURN
    IF ( _priorStatus <> BLANK (), IF ( 'Table'[Status] = _priorStatus, "F", "T" ) )

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.