Forum Discussion
Solved
Vlookup duplicate with aproximate values
Hello, I have a table with KM and SB and I need to know the subdivision, according to another table Trem KM SB H17 170,1 LEB D22 133,6 LAR W03 301,302 ZSN H21 81,52...
Once a relationship is created between two tables, add a new column in second table using the following dax:
=Related(FirstTableName[ColumnName])
In this case, I assume that KM is & KMI are related between the two fields.
I can't relate the 2 tables, because there are no columns with unique values.
The KM of the first table must be >= KMI and <KMF from the second table
You can create a column using IF or Lookupvalue statements too.
I would not do it justice to list the options here but see
- Zubair_Muhammad
Community Champion
You can use this column in Table 1 to get all equipments in Table 2 that fall in the range
Column = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Equipamento] ), FILTER ( Table2, Table1[KM] >= [KMI] && Table1[KM] <= [KMF] ) ), [Equipamento], ", " )or you can use this column if you want any of the matching equipments
Column 2 = CALCULATETABLE ( FIRSTNONBLANK ( Table2[Equipamento], 1 ), FILTER ( Table2, Table1[KM] >= [KMI] && Table1[KM] <= [KMF] ) )
