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...
Need Help
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    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

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
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

 

  • nandic's avatar
    nandic
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Great work Fowmy 
    I was unaware of this option "All rows" in group by and stuck there. Great solution!

  • RyanCatling's avatar
    RyanCatling
    New Member
    4 years ago

    Suprised it has to be so complicated! you would think this would be an inbuilt merge function like index-match in Excel

  • Zova's avatar
    Zova
    New Member
    3 years ago

    Hi Fowmy, when I open your link it doesn't show the file for me. Could you please send it again? Thanks!