PQB04 | Extract data from a folder | “CSV files” | Automatically update new data | PowerQueryBasics

#excel #powerquery
--------------------------------------------------------------------
Visit the website for more content: www.aaa-power.net
--------------------------------------------------------------------
0:00 Intro
1:28 Example explained
2:41 Extract data from a folder
4:36 Use sheet name as an input
6:06 Csv.Document
8:32 Transform data
10:46 Create a date column
12:52 Load data a pivot table
14:43 Add new data & auto update the report
---------------------------------------------------------------------
Excel Data Analysis Series: PQB “Power Query Basics”
PQB04: Extract data from folders “CSV files”
Extract data from a folder containing “CSV” files
Split columns by position
Use Csv.Document formula
Create date column considering your locale (regional settings)
Use file name as a new column in the query
Merge 3 columns to create new full date column
Load query to a pivot table and create sales report
Report will be updating automatically once you add new files to the folder
--------------------------------------------------------------------
To Download the excel files:
https://drive.google.com/open?id=1a9Z...
CSV files:
https://drive.google.com/drive/folder...
--------------------------------------------------------------------
To view the full play list
   • PQB | Power Query Basics  
--------------------------------------------------------------------
To subscribe:
   / @aaaexcelenglish  
---------------------------------------------------------------------
To follow on Facebook:
  / excelispower  
---------------------------------------------------------------------
To follow on LinkedIn:
  / amratef