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.
Hi,
How do i compare text across multiple columns ignoring any blanks and ignoring case.
e.g.
Column1 | Column2 | Column3 | Column4 | Column5 | Expected Result |
cat | cat | cat | cat | cat | TRUE |
cat | Cat | CAT | cat | cat | TRUE |
cat | cat | TRUE | |||
cat | cat | cater | cat | cat | FALSE |
In Excel, i used the following formula and it worked fine:
=SUMPRODUCT((A2:E2<>"")/COUNTIF(A2:E2,A2:E2&""))=1
Thanks for any help.
Solved! Go to Solution.
Both Solutions work. Thank You so much.
here's a fun way:
= SWITCH(TRUE(),[Column1]<>[Column2],FALSE(),[Column1]<>[Column3],FALSE(),[Column1]<>[Column4],FALSE(),[Column1]<>[Column5],FALSE(),TRUE())
Doesn't seem to work if there are any blank columns.
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |