how do I compare today with yesterday data dynamically where data in same table

Hi All,

I was trying to get solution for below requirement.

i was getting daily open orders with append all one month daily open orders report in same table.

and i am making new table with uniq value of last 2 days(3/1 and and 2/1)

 with status today and yesterday.

i am adding calculated column for today status and yesterday status

for today status calculation

completed status- order open 2/1 and not found in 3/1open orders

for new status - order open 3/1 not found in 2/1open orders

in progress avaialble in both dates.

My out put should be like below and it has to be dynamic with my date. if i swith date to 2/1 it has to comapre 2/1 with 1/1 date

i tried with calculated table but unfortunatly table is taking last date of main table not chnaging based on slicer selection.