Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Earliest Value based on filter/criteria

Hi,    I have a dataset as follows:   ID Date Success Score 123 11/19/2020 0 5 123 11/20/2020 1 6 123 11/21/2020 1 2 122 11/19/2020 0 8 122 11/20/2020 1 9 1...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a new column like

    Column = var _1 = minx(FILTER(Data, [ID] =EARLIER([ID]) && Data[Success] = 1),Data[Date])
return 
if(_1 =[date] ,minx(FILTER(Data, [ID] =EARLIER([ID]) && Data[Success] = 1 && [Date] =_1),[Score]),BLANK())
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create a new column like

Column = var _1 = minx(FILTER(Data, [ID] =EARLIER([ID]) && Data[Success] = 1),Data[Date])
return 
if(_1 =[date] ,minx(FILTER(Data, [ID] =EARLIER([ID]) && Data[Success] = 1 && [Date] =_1),[Score]),BLANK())
Anonymous's avatar
Anonymous
Not applicable
5 years ago

thanks amitchandak ! your solution worked great.