Merging two sheets in Power Query

Power Query
1

Hi All,

I am working on Sales Data and I want to merge date column .
I need help in solving this ,it can be through DAX or in Power Query.
It will be more clear with the screenshot and attaching the excel file with data.
OrderDate.xlsx (11.1 KB)

Problem
Problem1152Ă—648 17.5 KB

2

Hello @Nisha,

Thank You for posting your query onto the Forum.

In order to achieve the results based on the scenario that you’ve provided, you just need to do a simple merge operation between the two queries based on “Ordernumber” field which is common between the two tables. Below is the screenshot of the final results provided for the reference -

Final Results
Final Results781Ă—583 19.3 KB

I’m also attaching the working of the PBIX file for the reference purposes as well as recommend you to please go through the “Data Transformations and Modelling” course.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

Merge Two Tables - Harsh.pbix (16.3 KB)

3 Likes
3

Hi @Nisha, did the response provided by @Harsh help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

4

Thank you so much Harsh for your reply.
It solved the issue.