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" )
     
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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" )