Vote Here: https://forms.office.com/Pages/ResponsePage.aspx?id=AzbjXcO4-06rg5AtOyQeHEQGbPtdBrxLqFDLktGSNXBUMlJJUkRFNUlGM0M4Mk1WTFpNMlM2SDRaUS4u



Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1493Finished.xlsx
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1494 Finished.xlsx
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1495 Finished.xlsx
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1495-Part02-Start.xlsx
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1496 Finished.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so we can use the Line Level Product Criteria (Filter) to create a Shipping and Discount Amount Report by Product. This is a typical business problem where the grain (granularity) of the two Transaction / Fact Tables is different and in order to use a filter or condition / criteria from the Line Level Transaction / Fact Table we must first allocate the Header Level amounts to the Line Level.
Related Videos:
EMT 1493: Excel Formulas & PivotTable: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1494: DAX & Power Pivot: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1495 Part 02: Power Query w Group By Rows: Allocate Invoice Amounts To Line Item Table
EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table
EMT 1497: Vote For Your Favorite “Allocate Invoice Header Amounts To Transaction Line Item Table”

Excel Magic Trick 1497