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 Ite...
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.

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.

Kaii's avatar
Kaii
Helper I
4 years ago

Thank you SO SO MUCH!!