Forum Discussion
prasadhebbar315
Advocate I
Advocate ISummarize data based on conditions
Hello, I need help in creating a Result column from the below table based on the condition that both Col1 and Col2 should atleast contain Yes for a Serial_Number. If yes, then the entire Serial_Numb...
Result=IF(COUNTROWS(FILTER(Table,Table[Serial_Number]=EARLIER(Table[Serial_Number])&&Table[Col1]="Yes"&&Table[Col2]="Yes"))>0,"Yes","NO")
wdx223_Daniel Thanks a ton. Your solution has worked.
wdx223_Daniel
Community Champion
Community ChampionResult=IF(COUNTROWS(FILTER(Table,Table[Serial_Number]=EARLIER(Table[Serial_Number])&&Table[Col1]="Yes"&&Table[Col2]="Yes"))>0,"Yes","NO")