Excel 2013 Power Query 05

Create Dimension Table From Fact Table for PowerPivot During CSV File Import

DESCRIPTION

See how to Create Dimension Table From Fact Table for PowerPivot During CSV File Import:
(00:08) Problem Setup
(01:33) Create Dimension Table or Lookup Table from File Name in Fact Table. Use Power Query and From File / From Folder.
(02:33) Add Index Column.
(03:05) Import Fact Table. Use Power Query and From File / From Folder.
(04:31) Merge Tables to Allow CityID (Index) to populate in Fact Table for a relationship later in PowerPivot.
(05:35) Load tables to Data Model in PowerPivot.
(06:07) Add Formatting to tables in PowerPivot.
(06:20) Create Relationship in PowerPivot.
(06:48) Create Pilotable with Slicer.
(07:49) Add New Files to Folder

WORKBOOKS