Forum Discussion
Search for a value in another table
I have a table which has a column called "Konto" and a cell with the value of 8421 in this table.
Now i want to search in another table between two columns (Konto von - Konto bis) and give back the value #BWA-Zeile.
How can i do that in Power Query? I know how to do it as a calculated column, but this value is not in Power Query. Can someone help me?
Hier:
each Table.SelectRows(BWAgreift er auf die existierende BWA Tabelle zu. Anbei ein sample PBIX.
14 Replies
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
Your "Konto von" and "Konto bis" value ranges seem to be overlapping? What would be the expected outcome for Kontonummer 8600 ?
That would be better. Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
This is the table, where i have the values, which i need called "BWA" - i need the value BWA_Zeile, if the value is between "Konto von" and "Konto bis"
And i need the value in this table called "Import"
Und an welcher Stelle greift er auf welche Tabelle zu?
