Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Refer to previous value within a Matrix

Hey guys,   last 2 columns is my issue. I need the "Backlog Line not put away prior day" Value to calculate my SLAs. All columns values are measures. "Backlog Line not put away prior day" uses Toda...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago
    Hi 
    you can use the below, this should solve your problem.
     
    yesterday =
    VAR yd = MAX('calendar'[Date]) -1
    RETURN
    CALCULATE(
    [measure],
    ALL('calendar'), 'calendar'[Date] = yd
    )
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous you can simply use previousday function as mentioned previously

     

    Prev Day = 
CALCULATE( [Measure], PreviousDay( Calendar[Date] ) )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous you can use previousday function to get the value from previous date. It is adviseable to add date dimension in your model if you already don't have one.