Forum Discussion
Post ProdigyIF MATCH MULTIPLE COLUMNS (DAX MEASURE)
Hi,
I have 7 headers columns are (column A:H) US, INDIA, SA, SRL, PAK, BAN, AFG. Each columns contain two different status which is Matched and Not matched.
If those 7 columns are contain “Matched” then return Completed if any one of the columns are contain “Not Matched” then
return “Not Completed”.
Example
| US | INDIA | SA | SRL | PAK | BAN | AFG | STATUS |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| MATCHED | MATCHED | MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
| NOT MATCHED | NOT MATCHED | MATCHED | MATCHED | NOT MATCHED | NOT MATCHED | NOT MATCHED | NOT COMPLETED |
Saxon10 , Create a new column
if([US] = "MATCHED" && [INDIA] = "MATCHED" && [SA] = "MATCHED" && [SRL] = "MATCHED" && [PAK] = "MATCHED" && [BAN] = "MATCHED" && [AFG] = "MATCHED" ,"COMPLETED", "NOT COMPLETED")
3 Replies
- amitchandak
Super User
Saxon10 , Create a new column
if([US] = "MATCHED" && [INDIA] = "MATCHED" && [SA] = "MATCHED" && [SRL] = "MATCHED" && [PAK] = "MATCHED" && [BAN] = "MATCHED" && [AFG] = "MATCHED" ,"COMPLETED", "NOT COMPLETED")
Saxon10thanks for your quick reply. I have one more question incase headers US and AFS contains three different status which is Matched, Not Matched and not required. Then how can I apply the if conditions. Could you please advise.
- amitchandak
Saxon10 , As long as you need "Matched" when all 7 are matched this will work. Now if you need three output based on these 7 columns we can use the switch - https://www.youtube.com/watch?v=gelJWktlR80