SHARE

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

See how to Create Dimension Table From Fact Table for PowerPivot During CSV File Import:

  • 1.Problem Setup
  • 2. Create Dimension Table or Lookup Table from File Name in Fact Table. Use Power Query and From File / From Folder.
  • 3. Add Index Column.
  • 4. Import Fact Table. Use Power Query and From File / From Folder.
  • 5. Merge Tables to Allow CityID (Index) to populate in Fact Table for a relationship later in PowerPivot.
  • 6. Load tables to Data Model in PowerPivot.
  • 7. Add Formatting to tables in PowerPivot.
  • 8.Create Relationship in PowerPivot.
  • 9.Create Pilotable with Slicer.
  • 10.Add New Files to Folder

Download Video from here

powerquery-video-button

Download Sample DataSet for Practice from here

owerquery-sample-dataset-button

themiscellaneousblog
READ  PowerQuery: 2# Transform Data and Import Into PowerPivot or Excel Table