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.
I have two text columns (column A in data table A and column B in data table B -both data tables have id columns).
I want to create a table\matrix in the desktop page that contains an id column, column A, column B and then another column which indicates if A is the same as B.
I would like to avoid doing a query where I merge column A and B based on the id column, but will if there are no other viable options
Thank you!
Solved! Go to Solution.
Since you want a calculated column, use below.
A and B = IF(LOOKUPVALUE(TableB[TextA],TableA[TextA],TableB[TextA])=TableB[TextA],"Yes","No")
You can relate table A and B first. Then write a IF function to return "yes" if column A1 = column B1 I don't think you need to merge.
Thank you!
When trying to implement the following statement:
IF( EXACT( 'Table A'[A1]), 'Table B'[B1])), "yes", "no")
I get the error: A single value for column 'A1' in table 'Table A' cannot be determined. (for both tables)
It is my understanding that I need to add something in the statement so that column A1 and B1 are only compared when the id column in both tables are equal. Is this correct and how would I go about doing this?
Since you want a calculated column, use below.
A and B = IF(LOOKUPVALUE(TableB[TextA],TableA[TextA],TableB[TextA])=TableB[TextA],"Yes","No")
Hi
I get errors when using the same DAX
may I know how to edit?
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |