Forum Discussion

greenawayr's avatar
greenawayr
Helper I
5 years ago
Solved

Evaluate duplicate IDs on another column

Hi,    Hope this makes sense, but if it does, appreciate any help.   I have a table where I need to evaluate each set of duplicated ID's and output in a new column if that set meets a condtion. ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    greenawayr 

    you can also try this

    Column = if(CALCULATE(min('Sheet2'[Date]),ALLEXCEPT(Sheet2,Sheet2[ID]))<today(),0,1)

amitchandak's avatar
amitchandak
Super User
5 years ago

greenawayr , create a new column like

if(isblank(countx(filter(table, [ID] = earlier([ID]) && [Date] <today()),[Date])),1,0)