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 1366

DESCRIPTION Full Lesson on Power BI Desktop to build Product Analysis for Gross Profit with Average, Standard Deviation, Coefficient of Variation and Histogram Calculations and Visualizations: (00:04) Files to download (00:12) Introduction (04:42) Import Related [Read More >>>]

Excel Is Fun

Excel Magic Trick 1365

DESCRIPTION See how to import an Excel Power Pivot Data Model with tables, relationships and DAX Measures into Power BI Desktop using the File (Upper Left icon), Import, Excel Workbook option in Power BI Desktop. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1360

DESCRIPTION See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1350

DESCRIPTION Learn how to create formulas to make calculations in a Standard PivotTable. See how to Create a PivotTable Report with PivotTable Formulas for Year, Product & Region with Total Cost Of Goods Sold, Total [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 Is Fun

Excel Magic Trick 1269

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 11

DESCRIPTION See how to: (00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months (02:04) Group By Date: PowerPivot PivotTable: (02:07) Add Revenue Table to PowerPivot Data Model (02:46) [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 09

DESCRIPTION See how to create 9 different DAX functions or Calculated Fields (00:08) Overview of Reports we need to create (01:05) Calculated Fields Overview (01:58) Calculated Column For Net Revenue using ROUND and RELATED function [Read More >>>]