View My Drafts
Previous Day Amount =
VAR Var1 =
FILTER ( ALL ( Tracker[DATE] ), [DATE] < MAX ( Tracker[DATE] ) ),
CALCULATE ( SUM ( Tracker[AMOUNT] ), Tracker[DATE] = Var1 )
Hi Prem,In your Calendar create column Rank, then create column Rank related and then just use filter.
I am tired to copy/paste same solution as last 2 weeks I did it already 3 time. Review forum, you'll find it.Regards,