Excel Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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

Excel Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

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