Forum Discussion
Solved
Filter Query (or create new table) based on first (date) duplicate and values of 2 columns
Hello Everyone, I've tried my best to find the best solution for my issue on the forums, but got into a dead end, so im asking for help from scratch. instead of modifying my attempts, here it goes: ...
Aha, I think I follow now
Table 3 = VAR T1 = SUMMARIZE('Table','Table'[BATCH#],"First Date" , MIN('Table'[DATE])) VAR T2 = FILTER( NATURALINNERJOIN('Table',T1),[STATE]<> "Aprobado" && [PROCESS]="Tinto" && [First Date] = [DATE]) RETURN T2
Can you please post a mock-up of what the result table should look like?
Same as the one in my last post but only with the top result which is the ealiest date:
Aha, I think I follow now
Table 3 = VAR T1 = SUMMARIZE('Table','Table'[BATCH#],"First Date" , MIN('Table'[DATE])) VAR T2 = FILTER( NATURALINNERJOIN('Table',T1),[STATE]<> "Aprobado" && [PROCESS]="Tinto" && [First Date] = [DATE]) RETURN T2Thank you!