Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello dear PowerBI-Community
I have the following problem to solve.
As shown below, I have 2 tables in PowerBI that I can't edit in advance.
I would like to create another column in table 2 (orange column) and check whether the TransportID appears in the corresponding row in table 1 or not.
Table A:
transportID | … |
1 | … |
2 | … |
2 | … |
4 | … |
Table B:
transportID | … | exists in Table A |
1 | yes | |
2 | yes | |
3 | no | |
4 | yes | |
5 | no |
Any ideas?
I would be very grateful for your help,
Cheers!
qwertzuiop
Solved! Go to Solution.
Hi, @qwertzuiop
Exists in Table A = CALCULATE(COUNTROWS('Table A'),FILTER('Table A','Table A'[transportID]='Table B'[transportID]))> 0
Best,
Paul
Hi, @qwertzuiop
Exists in Table A = CALCULATE(COUNTROWS('Table A'),FILTER('Table A','Table A'[transportID]='Table B'[transportID]))> 0
Best,
Paul
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
85 | |
64 | |
59 | |
56 |