Forum Discussion

Shubham21's avatar
Shubham21
Frequent Visitor
8 years ago
Solved

Get date previous to the current row date

 

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])))

Need Help
  • SteveCampbell's avatar
    SteveCampbell
    8 years ago

    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
        )

1 Reply

  • SteveCampbell's avatar
    SteveCampbell
    Icon for Memorable Member rankMemorable Member
    8 years ago

    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
        )