Excel Is Fun

Excel Magic Trick 1496

DESCRIPTION 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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1495 Part 2

DESCRIPTION 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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1495 Part 1

DESCRIPTION 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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1494

DESCRIPTION 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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1493 Part 2

DESCRIPTION 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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1493 Part 1

DESCRIPTION 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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1492

DESCRIPTION In this video learn how to do Approximate Match Lookup in a DAX Calculated Column using two different methods. Topics: 1. Introduction & look back to last video where we used MAX Function on [Read More >>>]

Excel Is Fun

Excel Magic Trick 1491

DESCRIPTION Survey Results for “Lookup Latest Product Price” Winner of Free Book WORKBOOKS

Excel Is Fun

Excel Magic Trick 1490

DESCRIPTION In this video learn how to create a DAX Calculated Column for Exact Match Lookup and Approximate Match Lookup. See how to combine the two lookups in a formula to lookup the correct Volume [Read More >>>]

Excel Is Fun

Excel Magic Trick 1489

DESCRIPTION In this video learn how to create a single Excel formula that will lookup a product price and lookup the volume / quantity discount and deliver the correct discounted Product Price. See how to [Read More >>>]