You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • Help me out here.
    I love a power query. I love a merge. BUT I ALSO REALLY FUCKING LIKE NOT GROWING MY TABLES AFTER MERGING.

    How do I replicate the vlookup in powerquery? All I Want To Do : match this key to that key and when it matches bring back [code] else FUCKOFFDAMO

  • This might be what you want:

    = Table.AddColumn(#"Source", "NewColumn", each try Table2{[z=[a]]}[x] otherwise null)
    

    2 Attachments

    • Screenshot 2024-07-16 130126.jpg
    • Screenshot 2024-07-16 130111.jpg
About

Avatar for aggi @aggi started