If the raw data appears more than once, mark it differently

[Anonymous]

Hello All, I need a help with following: if the PackageCode appears more than one time in the row "Test Status" shall show first occurance as "Test" and the rest for the same PackageCode as "Retest" as shown. I have tried this code, but it turns everything to "Retest". I have simulated what I expect in Excel as an example below

[danielkrol]

With EARLIER you are comparing earlier packagecodes, not by date.

Can you post your data as csv, or ad your pbix? It will make it easier to create sample code for you.

[amitchandak · Accepted solution]

@Anonymous , try like as new column

if(countx(filter(Table, table[package code] =earlier(table[package code] ) && table[StatechangeTS] <=earlier(table[StatechangeTS] )),table[package code] )=1, "Test","Retest")

[Anonymous]

Thanks again for response, 

How can I put the filter in the script that it takes ONLY results for Static tester in the calculation? so when the same module appears in static and dynamic tester, one of them does not count as restest, cause it is being ignored. 

PS: without filtering out the "Destination" with column filter option in the table top