Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two tables.
Table A looks like this:
Number | RangeFrom | RangeTo |
1 | 17000 | 17999 |
2 | 18000 | 18999 |
Table B looks like this:
Number | Name |
17001 | Tom |
17002 | Michael |
19000 | Brad |
I want to create a calculated column in Table B that checks for each number to see if it is in the range and if so, returns a 1.
For 17001 and 17002 1 should be returned, for 19000 a 0.
Currently my calculation looks like this.
if(Table_B[Number]>=related(Table_A[RangeFrom]) && Table_B[Number]<=related(Table_A[RangeTo]) ,1,0)
Thank you for help!
Solved! Go to Solution.
Hi @tim_m15
Please use
=
MAXX (
FILTER (
'Table A',
'Table B'[Number] >= 'Table A'[RangeFrom]
&& 'Table B'[Number] <= 'Table A'[RangeTo]
),
'Table B'[Name]
)
Hi @tim_m15
Please use
=
MAXX (
FILTER (
'Table A',
'Table B'[Number] >= 'Table A'[RangeFrom]
&& 'Table B'[Number] <= 'Table A'[RangeTo]
),
'Table B'[Name]
)
Great answer thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |