Forum Discussion

Kaii's avatar
Kaii
Helper I
4 years ago
Solved

How to show which items have changed between two dates

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

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

4 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.