Forum Discussion

boykin188's avatar
boykin188
Frequent Visitor
7 years ago
Solved

Multiple rows per unique ID

I have a table with multiple rows per unique ID, and some columns which reference "flags" (basically a 1 or  0) that something has occurred relative to that ID. Due to the way the data is structured,...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    You can use Min / Max

     

    FlagA = If(Max(Table1[ColA]) = 1, "Yes", "No")
     
     
Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can use Min / Max

 

FlagA = If(Max(Table1[ColA]) = 1, "Yes", "No")
 
 
  • boykin188's avatar
    boykin188
    Frequent Visitor
    7 years ago

    Thanks! Worked great!