compare data sets based on dates

Hi  Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

Date =
DISTINCT('Table'[runid])

2. Create measure.

Measure_A =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[runid])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[runid])
var _maxID=SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[runid]=_maxdate),"ID",'Table'[Id])
return
IF(
    MAX('Table'[runid]) = _mindate&&MAX('Table'[Id])in _maxID&&
    MAX('Table'[Status])<>
    MAXX(FILTER(ALL('Table'),'Table'[runid]=_maxdate&&'Table'[Id]=MAX('Table'[Id])),[Status])
    ,1,0)

Measure_B =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[runid])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[runid])
var _minID=SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[runid]=_mindate),"ID",'Table'[Id])
return
IF(
    MAX('Table'[runid]) = _maxdate&&NOT(MAX('Table'[Id]))in _minID,1,0)

Measure_C =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[runid])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[runid])
var _maxID=SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[runid]=_maxdate),"ID",'Table'[Id])
return
IF(
    MAX('Table'[runid]) = _mindate&&NOT(MAX('Table'[Id]))in _maxID,1,0)

 3. Place [Measure_A], [Measure_B], [Measure_C] into Visual's Filter and set it to 1.

4. Result:

A and D results in a Visual.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly