top of page
Search

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




174 views0 comments

Recent Posts

See All

CURRENTMONTH( ) FUNCTION in EXCEL?

The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http

bottom of page