top of page

Power Query Editor - Merge Queries - Power BI & Excel

Managing Excel Data is some times bit complicated !

Let me explain a scenario which is a real time scenario from a Student ;

The Data contains -

Sales Table (Only Columns available - Date and Sales Value) ,

"No" Product information is in Sales Table.

Product Table contains Data as mention below in Each Row, like

1 Jan 2020 - 31 Jan 2020 - Apple

1 Feb 2020 -28 Feb 2020 - Orange;

and so on

Now I need to add a Column - "Product Name" to the Sales Table based on the Range of Dates available in Product Table.

Is this Tricky?? Watch this video to understand how to solve this in Power Query Editor

175 views0 comments


bottom of page