Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Find match in previous value

Hi, I'm looking for a solution for the below issue,   I have a table where in every day I get new data post refresh, I want to check the data of a perticular column eg: Name in the below table and ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Previous days Name exist? CC =
    VAR _currentdate = Data[Date]
    VAR _previousdaystablenamecolumn =
    SUMMARIZE ( FILTER ( Data, Data[Date] < _currentdate ), Data[Name] )
    RETURN
    IF ( Data[Name] IN _previousdaystablenamecolumn, "Yes", "No" )
     
     
     
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for picking up my query, Appreciate it.

 

I want to know if one more time Dawood name appears will the previous value become "No" and current date value becomes "Yes" ?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Thanks for the feedback.

    If one more Dawwod is added, 1st previous Dawood already has the 2nd previous Dawood.

    So, I think, it will still show yes.

    You can try.