### Excel Magic Trick 1424

DESCRIPTION See how to calculate Average, Moving Average at Different Granularity in both DAX and Excel Formulas: (00:14) Introduction (00:27) What is Granularity? (02:15) Look at Data Model and Hide Columns from Client Tool (03:29) [Read More >>>]

### Excel Magic Trick 1419

DESCRIPTION See how to use the RANKX Function in DAX. Learn : (00:15) Introduction. Look at Finished Data Model PivotTable. Look at Established Data Model. (02:24) Create Total Profit Formula, start PivotTable. (04:14) Discuss how [Read More >>>]

### Excel Magic Trick 1418

DESCRIPTION See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer: (00:10) Introduction (01:31) PivotTable #1 for Total Profit per Product and Ranking [Read More >>>]

### Excel Magic Trick 1408

DESCRIPTION See how to create a DAX Measures for Moving 12 Month Average on Daily Sales: (00:15) Introduction and comparison to formulas created in Excel Magic Trick 1406. (01:07) Discussion of Filter Context and how [Read More >>>]

### Excel Magic Trick 1407

DESCRIPTION See how to calculate Monthly Totals for Sales from Daily Records and Ad Costs from Month Records using The Data Model, Two Fact Tables with a Relationships to Data Table, and Two DAX Measures. [Read More >>>]

### Excel Magic Trick 1403

DESCRIPTION Learn about the difference between Explicit and Implicit DAX Measures: (00:10) Introduction to Explicit and Implicit DAX Measures (01:33) Create Implicit Measures and see these six problems: 1) Number Field will use SUM Function, [Read More >>>]

### Highline Excel 2016 Class 23

DESCRIPTION In this video learn about a free download called Power BI Desktop that is a single program that does all that Excel’s Power Query & Power Pivot can do, and more. Comprehensive example of [Read More >>>]

### Highline Excel 2016 Class 22

DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [Read More >>>]

### Excel Magic Trick 1398

DESCRIPTION See how to: (00:15) Introduction (02:45) Look at Data Model in Download file. This is the Data Model that we start with at beginning of video. (04:55) Add Upper & Lower Limit “Regular Increment” [Read More >>>]

### Highline Excel 2016 Class 20

DESCRIPTION In this video learn about: (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including [Read More >>>]