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] ) )
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
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
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This is genious! Thx. Works great. I am new to PBI still got a lot to learn.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous you can simply use previousday function as mentioned previously

       

      Prev Day = 
CALCULATE( [Measure], PreviousDay( Calendar[Date] ) )
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Both works fine. Yours is shorter :)