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

Excel Is Fun

Excel Magic Trick 1454

DESCRIPTION Count Customer Totals Between Upper & Lower Limits For Each Month using a DAX Measure in either Power Pivot or Power BI Desktop. See the DAX Functions: COUNTROWS, FILTER, MAX and MIN and an [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 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 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 >>>]

Excel Is Fun

Excel Magic Trick 1375

DESCRIPTION See how to: (00:01) How to Navigate to sections of this video (00:46) Introduction (01:32) What is an OR Logical Test using OR Criteria (02:30) Fundamental Problem with an OR Logical Test on Two [Read More >>>]

Excel Is Fun

Excel Magic Trick 1322

DESCRIPTION See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: (00:16) [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 10

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name [Read More >>>]