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.
