1 of 1 people found this helpful
The problem is the calculation for yesterday is using a table calculation (last) which needs [Date] to be on the view. An alternative is to use an LOD expression for the current time:
This should compare [Date] with the latest date available in the data set. The rest works itself out. The workbook is attached.
Hope that helps!
Thank you So very much Santiago