Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
I would like to write a DAX statement that compares the values of a column in Table A to a column in Table B.
Table A has unique values
Table B has duplicate values because the data represented is daily performance
Rough expression of the logic:
If the Transation ID in Column X of Table A matches a Transaction ID in Column Y of Table B, True else False.
Thanks!
Hi @Anonymous
Try this
New column = IF ( TableX[TrnsactionID] = RELATED( TableY[TransactionID]), TRUE(),FALSE() )
Thanks
Raj
@Anonymous
I used this logic based on your recommendation:
Column = IF(Inv[UID]=RELATED(Sheet1[UID]),"Sold","Available")
The output in thge table view looks like this:
However, when I am in the Data View the column shows Available and Sold. I can't figure out why I can't show "Available" on my table visualiizaiton.
Hi @Anonymous,
Could you please share a sample data to have a test and post your desired result if possible?
Regards,
Daniel He
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
141 | |
109 | |
69 | |
55 |