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

DESCRIPTION See how to use the : DAX functions DISTINCTCOUNT & CONCATENATEX to Count & List Stores that Customers Have Visited. WORKBOOKS

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

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