How to show which items have changed between two dates

[Kaii]

I have a table that contain 2 columns like below

Date             Items
01/01             A
01/01             B
01/01             C
02/01             A
02/01             B
As you can see Item C are only exist in 01/01. Now I want to create a table visual that shows which Item is unique between selected date and one day before that day. 
the result should be something like 
Unique Value between 01/01 and 02/01 is  Item C



Thanks in advance

[v-yalanwu-msft · Accepted solution]

Hi, @Kaii ;

You could try to create a measure.

Measure = 
var _count=CALCULATE(COUNT('Table'[Items]),FILTER(ALL('Table'),[Items]=MAX([Items])&&( [Date] =MAX('Date'[Date]) ||[Date] =MAX('Date'[Date])-1)))
return IF(_count=1,MAX([Items]))

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kaii]

Thank you SO SO MUCH!!

[Kaii]

anyone ? 😫

[Kaii]

😥