Text Value previous day

[Broly]

Hi,

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

ID	SupplyScheme	Date
123	ABC	11/16/2022
1234	ABC	11/16/2022
12345	ABC	11/16/2022
123	ABC	11/15/2022
1234	ABC	11/15/2022
12345	EFG	11/15/2022

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 :

ID	SupplyScheme	Date
123	ABC	11/16/2022
1234	ABC	11/16/2022
12345	ABC	11/16/2022

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 : 

ID	SupplyScheme	Date	supplyscheme yesterday
123	ABC	11/16/2022	ABC
1234	ABC	11/16/2022	ABC
12345	ABC	11/16/2022	EFG

Is there an simple way to achieve this ?

thanks in advance 

[Broly]

thank you very much for your help ! 

[Bifinity_75 · Accepted solution]

Hi @Broly , try this measure:

supplyscheme yesterday = CALCULATE(max(Table1[SupplyScheme]),
FILTER(ALLEXCEPT(Table1,Table1[ID]),MAX(Table1[Date])-1))

The result:

Best regards