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 that works. I have a query regards to report. 

 

If I have to create a measure to display the count as to number to names that has been found previously as of today (I want to consider the last refresh day or the recent date in date column for this calculation)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Perhaps you can try to use today function to replace the variable with the current date and use it to calculate. Then the calculated result will auto changes based on system DateTime. 

    Notice: power bi data model does not include cache history records features, these results will be replaced every time the system datetime changes.

    Regards,

    Xiaoxin Sheng