Get date previous to the current row date

[Shubham21]

Hi, I want to get the previous date to what is available in my current row, I cannot use -1 or -2 as the Intervals are random.

I am doin this but it isn't helping

Prev_Date = CALCULATE(LASTDATE(TransactionForecast_Latest_Region[day]),FILTER(TransactionForecast_Latest_Region,TransactionForecast_Latest_Region[day]<MAX(TransactionForecast_Latest_Region[day])))

[SteveCampbell · Accepted solution]

Is this a calculated column?

If so, you can try:

Prev_Date =
VAR _CurrentDate = TransactionForecast_Latest_Region[day]
RETURN
    CALCULATE (
        LASTDATE ( TransactionForecast_Latest_Region[day] ),
        FILTER (
            TransactionForecast_Latest_Region,
            TransactionForecast_Latest_Region[day] < _CurrentDay
        )
    )

A measure (assuming it has row context):

 

Prev_Date =
VAR _CurrentDate = FIRSTNONBLANK(TransactionForecast_Latest_Region[day],0)
RETURN
    CALCULATE (
        LASTDATE ( TransactionForecast_Latest_Region[day] )
            ,ALL(TransactionForecast_Latest_Region[day])
           , TransactionForecast_Latest_Region[day] < _CurrentDay
        )