Forum Discussion
Solved
Unable to join two tables based on condition Power Query
I have Table A and Table B and i need to get the Tranche_ID from Table B. Table A ID_Client ID_Collaborateur Nombre_Dossiers 1 2 6 1 3 4 2 3 2 Ta...
Salut, AsmaBenhassine9 , ta formule marche bien de mon côté 😂; la formule complete est comme ça
#"Colonne Ajoutée" = Table.AddColumn(#"Renamed Columns", "ID_Tranche", each Table.SelectRows(TableB, (t) => t[Min_Tranche]<=[Nombre_dossiers] and t[Max_Tranche] >= [Nombre_dossiers])[ID_Tranche]{0})
it works very well. Thank you 🙂