Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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_Number should have Yes in Result column.
Serial Number 200 and 400 contains "Yes" atleast once in both Col1 and Col2 , therefore it has "Yes" in Result.
Serial_Number | Col1 | Col2 | Result |
100 | Yes | No | No |
100 | No | No | No |
100 | No | Yes | No |
200 | Yes | Yes | Yes |
200 | No | No | Yes |
300 | No | Yes | No |
300 | Yes | No | No |
300 | No | No | No |
400 | No | No | Yes |
400 | Yes | No | Yes |
400 | Yes | Yes | Yes |
Solved! Go to Solution.
Result=IF(COUNTROWS(FILTER(Table,Table[Serial_Number]=EARLIER(Table[Serial_Number])&&Table[Col1]="Yes"&&Table[Col2]="Yes"))>0,"Yes","NO")
@prasadhebbar315
If you want to create this calculation in the table, go to data view, click on new column and type the below formula:
Result=IF(COUNTROWS(FILTER(Table,Table[Serial_Number]=EARLIER(Table[Serial_Number])&&Table[Col1]="Yes"&&Table[Col2]="Yes"))>0,"Yes","NO")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |