Excel Is Fun

Excel Magic Trick 1498

DESCRIPTION In this video learn how to Transform Two Fact Tables (Header Invoice and Invoice Line Item Tables) with Dimension Tables into a Proper Star Schema using Power Query inside Power BI Desktop. The Power [Read More >>>]

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 >>>]