Forum Discussion
Validate the Data between two tables
Dear experts,
I am currently building a report to validate the Location ID stored in a Participant Table. I wish to add a custom column "Location Validation Result" by comparing the location ID stored in Participant Table with Location Table. If it is a value stored in the Location Table, the result in that custom coumn will show Valid. If not found, the value will be Invalid.
Participant Table:
Location Table:
Is it possible to use the express to do that?
Many thanks for your great help!
If you have a relationship between your Location ID columns, then you could do this:
Column = IF(NOT(ISBLANK(CALCULATE(COUNTROWS('Locations')))),"Valid","Invalid")Also, next time, please post text instead of screen shots of your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
4 Replies
Why us US2222 invalid?
Hi Greg! Sorry, that is a typo. US2222 is valid.
If you have a relationship between your Location ID columns, then you could do this:
Column = IF(NOT(ISBLANK(CALCULATE(COUNTROWS('Locations')))),"Valid","Invalid")Also, next time, please post text instead of screen shots of your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
