Forum Discussion
Solved
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 : ID SupplyScheme Date 123 ABC 11/16/2022 1234 ABC 11/16/2022 12345 ABC 11/1...
Hi Broly , try this measure:
supplyscheme yesterday = CALCULATE(max(Table1[SupplyScheme]), FILTER(ALLEXCEPT(Table1,Table1[ID]),MAX(Table1[Date])-1))The result:
Best regards
thank you very much for your help !