Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Merging Tables and picking the closest date

Hello,   I'd like to know if anyone knows how to do this using Powerquery?   Table1: ID Date SubID 1 7/22/2020 5:49:55 PM 111 2 7/22/2020 3:12:11 PM 222...
  • Fowmy's avatar
    6 years ago

    Anonymous 

    I have attached the file for you to download and check the steps. I created without using custom M coding, all from GUI so you can go through the steps

    Download the file below



    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn