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.

     

SvenJ's avatar
SvenJ
Helper III
4 years ago

lbendlin This is not a problem - i can fix it to 8599 and start the other line with 8600

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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. 

    • SvenJ's avatar
      SvenJ
      Helper III
      4 years ago

      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"

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Kannst Du das bitte in benutzbarem (kopierbarem) Format posten?  Bilder sind nicht sehr hilfreich.