Forum Discussion

ratercero's avatar
ratercero
Helper III
9 years ago
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: ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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
ratercero's avatar
ratercero
Helper III
9 years ago

Same as the one in my last post but only with the top result which is the ealiest date:


 

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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
  • ratercero's avatar
    ratercero
    Helper III
    9 years ago

    Thank you!