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 2 tables below.
Table 1
Type | First | Last |
A | 1 | 3 |
B | 7 | 10 |
C | 12 | 15 |
Table 2
Number | Returned Column |
2 | A |
12 | C |
5 |
The red column is the column I want returned.
Essentially, I want to check if the "Number column" in Table 2 is between "First" and "Last" columns in Table 1. If it is between the 2 values, I want it to return the Type column from Table 1.
Hope this makes sense, any help appreciated!
Try
maxx(filter(table2,table2[Number]>=table1[First] && table2[Number]<=table1[Last]),table1[Type])
Hi Amit - You replied on top of my DAX option... does that mean my formula does not work and that's why you gave another option?
Thanks
Hi there -
I have created Table1 with the exact same data you provided and Table2 was created as follows:
1. Table2 was created with just 1 column with that data you have.
2. Second column is a calculated column with the following DAX code and it worked fine for me.
Please check at your end, and if it works for you as well please let me know.
The code is here:
Regards
E
Hi!
I'm fairly certain that yours would work. I am have trouble with memory and it is unable to complete the calculation for the column...
Thank you though!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |