How to merge and join two tables by date?

[Cortana]

I have two tables like the following- 

Table 1:

Table 2:-

I want a table like this-

Is it possible? 

[amitchandak · Accepted solution]

@Cortana , Use Append in power query and try

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

Append Tables (Power Query)
https://www.youtube.com/watch?v=KyXIDInZMxk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=15

[Cortana]

Thanks for your suggestions. I have tried that one. Does not work.

[PijushRoy]

Hi @Cortana 

Please check the DataType of the Date column, 
All table you want to join should be same datatype
Means
Table A, if Date column datatype is Date, then Table B Date column datatype should be Date
Table A, if Date column datatype is Datetime, then Table B Date column datatype should be Datetime
Table A, if Date column datatype is Text, then Table B Date column datatype should be Text
Check and try

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[Cortana]

Thanks a lot. Actually, my real data has many columns. It was messed up. It's solved now with append queries. Thanks again.