Forum Discussion
Validate the Data between two tables
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
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
Hi Greg, thank you so much for your help! I will post text next time. Thank you again for your help and advise!