Forum Discussion

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
3 years ago
Solved

Group by

Hi,  Thanks for looking at my post.    I am trying to link 2 tables and i wanted to get unique number rather than repeating numbers to connect two table.  What i am looking for is in "Transform d...
  • rrm121812's avatar
    rrm121812
    3 years ago

    HI,

     

    You can follow the below steps to achieve the result:

    1. Go to Transform Data-->Group By in Power Query Editor

    2. Fill the Group By pop up window like this: 

    You will see the result as expected.

     

    Before:

    After Group By:

     

     

    Regards,

    Ritu

     

    Please Accept the answer as solution if this solves your problem. Happy to help. ðŸ˜Š

     

  • rrm121812's avatar
    rrm121812
    3 years ago

    It is because Date column datatype is set to String. If you convert it into Date, it will resolve the issue.

     

    If you find this insightful, please give Kudos and Accept it as a solution.

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
3 years ago

Thanks a lot for your time and effort. One last thing in your logic is it is taking max date. That is if two dates, one is 30/02/2020 and other one is 20/03/2023, it is considering first one as the max date is 30th. Is there anyway to find solution for this pleasE?

 

thanks a lot and thanks a ton for your help again

rrm121812's avatar
rrm121812
Icon for Helper II rankHelper II
3 years ago

It is because Date column datatype is set to String. If you convert it into Date, it will resolve the issue.

 

If you find this insightful, please give Kudos and Accept it as a solution.