Measures (Implicit & Explicit) in Power Pivot || SUMX Function - #06
In this video you will learn the difference between implicit and explicit measures in Power Pivot. In addition, you will learn how to use the SUMX function in the data model. You will also understand when to use measures or calculated columns.
Don't forget to like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
0:22 Introduction
0:52 Implicit measures
1:22 Explicit measures
1:34 Calculation area
2:06 Sum function
2:58 AutoSum
3:30 SUMX function
4:56 Create a measure in the workbook
6:18 When to use measures or calculated columns
Connect with me on:
Instagram and Facebook @youexceltutorials
Twitter @youexceltutor LinkedIn @bunmisanusi
Other Videos
Excel tables and Pivot tables • Excel Tables & Pivot Tables
Connect Multiple Excel Tables in a Pivot Table (with Power Pivot) • Connect Multiple Excel Tables in a Pi...
Import data from External Data in Power Pivot (Direct Import -Excel & Text files) • Direct Import from External Data (Exc...
Define and create relationships in Power Pivot • Define and create relationships in Po...
Create a Pivot Table with Power Pivot Data Model • Create a Pivot Table with Power Pivot...
Download the practice files here https://drive.google.com/drive/folder...
“Each of you should use whatever gift you have received to serve others, as faithful stewards of God’s grace in its various forms.” (1 Peter 4:10) NIV
Смотрите видео Measures (Implicit & Explicit) in Power Pivot || SUMX Function - #06 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь YouExcel Tutorials 15 Апрель 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,213 раз и оно понравилось 30 людям.