I have a table as follow :
Please keep in mind that I dont have a date column in the table but I use a date table.
I want to create a measure to get the previous day supply scheme.
When I use the "previousday()" function to get the previous day quantity, it works fine.
I actually use this formula and it works fine as well :
Qty previousday = CALCULATE(SUM(Table[quantity),FILTER ( ALL ( 'Date Table' ), 'Date Table'[Date] = MAX('Date Table'[Date]) - 1 ))
Problem is now I want to get the previous day supply scheme. Any easy way of doing this ?
Thanks for you help