M Query Same Table

[Anonymous]

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

[Anonymous]

Hi team,

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

Thanks

[v-xicai]

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.

[amitchandak]

@Anonymous , are you not getting the new table in merge option

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

Hi @Anonymous ,

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

Thanks.

Aiolos Zhao

[Anonymous]

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]

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