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...
Need Help
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