Refer to previous value within a Matrix

[Anonymous]

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 Today()-1 which is fine but with how PBI works it does not show any value for prior day as each row is displayed for one specific Date. So what i am asking is there a way to transfer my "No Putaway" (which is the same as the Backlog) from a prior Date to the next Date? And if not do you have any other ideas on how to achive this kind of matrix.

[Mariusz · Accepted solution]

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

)

[Mariusz · Accepted solution]

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]

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

[Mariusz]

Hi @Anonymous 

If you new to Power BI and you're looking to learn DAX check out the link below.

This will give you a good strat

https://www.sqlbi.com/learn/introducing-dax-video-course/

Many thanks

Mariusz

[parry2k · Accepted solution]

@Anonymous you can simply use previousday function as mentioned previously

Prev Day = 
CALCULATE( [Measure], PreviousDay( Calendar[Date] ) )

[Mariusz]

@parry2k  agree your solution is much simpler and the result is the same

[Anonymous]

Both works fine. Yours is shorter 🙂

[parry2k]

@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.