Calculate previous date relative to row context date

DAX DAX Calculations
2

@hbreakey,

Welcome to the forum – great to have you here.

This measure should do the trick for you:

Prev Dist ID = 

VAR SelDate = SELECTEDVALUE( Data[Upload Date] ) 

VAR PrevDate = 
CALCULATE(
    MAX( Data[Upload Date] ),
    FILTER(
        ALL( Data ),
        Data[Upload Date] < SelDate 
    )
) 

VAR Result = 
CALCULATE(
    MAX(Data[Distinct ID Count by Upload Date] ),
    FILTER( ALL( Data ), Data[Upload Date] = PrevDate )
) 

RETURN
Result

image

The previous row pattern in Power PI can be tricky initially, particularly if you come from an Excel background where it is handled entirely differently. To understand this pattern and all its major variations, check out the entry on this pattern written by Enterprise DNA Expert @Greg:

I hope this is helpful.

– Brian