Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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
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
Hi Greg, thank you so much for your help! I will post text next time. Thank you again for your help and advise!
User | Count |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
106 | |
88 | |
64 | |
63 |