Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

M Query Same Table

Hi Friends,

I have query for Power Query Editor mode, below table get Plant wise Oldest date ,

 

I tried GroupBy but after that i can't merge another table, so please help. (only Query Editor mode)

 

Thanks

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    What do you mean you can't merge another table? could you please show the sample?

     

    Thanks.

    Aiolos Zhao

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      i tried to get oldest date in Group by (Edit Query ) however next step is merge another tahe in to grouped table.

       

      Thant I can't do "it shows (left table) hide.

       

      Thanks,

      Kali

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        I tried it on my desktop, it works.

         

        I don't see your data model so I don't know what kind of error or specific problem you met.

         

        Sample table:

         Using group by

        another table for merge:

        After merge:

         

        no issues.

         

        Aiolos Zhao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi team,

     

    Can you help Query editor , how can i get oldest date in palt wise.

     

    Thanks

    • v-xicai's avatar
      v-xicai
      Community Support
      6 years ago

      Hi Anonymous ,

       

      You may use "Group By" option to get oldest date for every Plant category.

      Best Regards,

      Amy 

       

      Community Support Team _ Amy

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.