Text Value previous day

Hi,

I have a table with ID, a text (supply scheme) and a date column that comes from a Date table :

What I currently display is a table visual that shows today's data (just a filter onthe date column to only get today's data) like this :

Now what I want is to know what was the supply scheme yesterday by creating a measure (I'm in live connection). So something like this : 

Is there an simple way to achieve this ?

thanks in advance