Excel Is Fun

Excel Magic Trick 1451

DESCRIPTION Topics in This Video: (00:04) How to Download Files. (00:14) Introduction to building Data Model with Relationships and DAX Formulas without buying Power Pivot in Excel 2016. (02:47) Import Tables and Build Relationships using [Read More >>>]

Excel Is Fun

Excel Magic Trick 1449

DESCRIPTION Video shows how to create DAX Formulas for Change & % Change formulas for both Month Over Month and Year Over Year. Extensive discussion about the hows and whys of how the formula calculates. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1443

DESCRIPTION Learn how to calculate Sales per working day based on a Data Model with Sales and Data Table. See the DAX Functions: CALCULATE, COUNTROWS, SUM, CROSSJOIN, VALUES, SUMX, IF, FILTER and MAX. Learn how [Read More >>>]

Excel Is Fun

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

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