Need help to combine tables

[Anonymous]

Can some  help me, how to merge above 2 tables into one.Both tables have different date formate, but i want to combine both the table into one single table. Sql query will also help.

[ryan_mayu]

@Anonymous 

i think you need to have the same column in both table

you can extract year and month from datekey column

Then you can merge queries. pls see the document below

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data