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 1429

DESCRIPTION See how to rank values in Power Query using an Index, the Group By feature and MIN Function. 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 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 1367

DESCRIPTION How to make Calendar Table in Power BI Desktop? See how to create three types of Calendar Tables in Power BI Desktop using the CALENDAR Function and various other functions: (00:02) Files to Download [Read More >>>]

Excel Is Fun

Excel Magic Trick 1325

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array [Read More >>>]

Excel Is Fun

Excel Magic Trick 1321

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER [Read More >>>]

Dueling Excel

Dueling Excel 150

DESCRIPTION See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100: (00:13) Method 1: IF function and array operation inside MIN function inside [Read More >>>]

Excel Is Fun

Excel Magic Trick 1303

DESCRIPTION Learn how to to create three different formulas to calculate minimum value greater than zero: (00:13) Introduction (01:00) Before Excel 2010: =MIN(IF(C4:T4 greater0,C4:T4)) (03:05) Excel 2010 – 2013: =AGGREGATE(15,6,C4:T4/(C4:T4 greater0),1) (04:53) Excel 2016 or [Read More >>>]

Dueling Excel

Dueling Excel 143

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and [Read More >>>]