### Excel Magic Trick 1442

DESCRIPTION In this video see how to use the EXCEPT DAX Function & Excel Existing Connections Edit DAX feature to Extract Items in List 1 that are NOT in List 2. WORKBOOKS

### Excel Magic Trick 1440

DESCRIPTION See how to perform an OR Logical Test on Two Columns using the DAX IN Operator and the DAX OR Function. The goal is to create a Data Model PivotTable with Row Area Criteria [Read More >>>]

### Excel Magic Trick 1439

DESCRIPTION Using Excel 2016, see how to use a DAX Formula with CALCULATE Function, the SUM Function and the IN Operator to create two formulas for adding sales based on Product Groups. This example will [Read More >>>]

### Excel Magic Trick 1437

DESCRIPTION See how to build a DAX Query OR Logical Test using the IN Operator to Pull Sales Team Data to an Excel Sheet from the Power Pivot Data Model. See the DAX Functions: CALCULATETABLE [Read More >>>]

### Excel Magic Trick 1435

DESCRIPTION See how to query the Data Model with DAX Code to Export Data to an Excel Sheet: (00:14) Introduction, including looking at Data Model that downloadable file contains (02:13) Use Existing Connections in Data [Read More >>>]

### Excel Magic Trick 1434

DESCRIPTION See how to use the DAX SAMPLE Function in Excel 2016 to extract a sample of size n from a Data Set. WORKBOOKS

### Excel Magic Trick 1433

DESCRIPTION Because we don’t have an F9 key to evaluate formula elements like we do in Excel, learning how to materialize or evaluate or “see” DAX Formula elements is important. In this video see three [Read More >>>]

### Excel Magic Trick 1432

DESCRIPTION See how to create nine DAX Formulas that build a Confidence Interval: (00:13) Introduction to the Confidence Interval example, reference video about Statistics, and introduction to Data Model used in this video (03:34) Formula [Read More >>>]

### Excel Magic Trick 1430

DESCRIPTION See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate of Return of Cash Flows that occur at irregular date intervals. WORKBOOKS

### Excel Magic Trick 1427

DESCRIPTION See how to use GEOMEANX and other DAX Formulas to calculate the Average Counpounding Rate per Period and a Future Value Calculation. Topics: (00:13) Introduction (01:09) Data Model Setup (02:27) GEOMEANX DAX function to [Read More >>>]