Forum Discussion

SvenJ's avatar
SvenJ
Helper III
4 years ago
Solved

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 t...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    4 years ago

    Hier:

    each Table.SelectRows(BWA

    greift er auf die existierende BWA Tabelle zu.  Anbei ein sample PBIX.

     

lbendlin's avatar
lbendlin
Super User
4 years ago

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 ?

  • SvenJ's avatar
    SvenJ
    Helper III
    4 years ago

    I would fill down the column "'#BWA_Zeile", means the result should always the column "BWA_Zeile" - in this case "1017"

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      My point is that 8600 should not be present in both ranges.