2^ Lesson
In this lesson we're going to find out what PowerPivot's Calculated Fields and Measures are, we'll understand their use and we'll study how PowerPivot manages these 2 ways of creating measures using the DAX language.
=========== S O S T I E N I M I =================
Subscribe to this channel to access the benefits: / @lodovicodincau
Buy a product: lodovicodincau.myspreadshop.it/
Donate: www.paypal.com/donate/?cmd=_d...
======= SAFE AND AFFORDABLE SOFTWARE! ==
Office, Windows, Antivirus, VPN, Server: mrkeyshop.com/it/?MrKey=484
======= MY EQUIPMENT ===============
Mouse: amzn.to/3s1XwF2
Yeti microphone: amzn.to/3MDCggU
Microphone without stand: amzn.to/3LAoWcS
Yeti filter: amzn.to/3KwKAO2
Sony Alpha 6400L: amzn.to/3t5cN8u
Elgato Stream Deck: amzn.to/3NDf0RM
Elgato Cam Link 4K: amzn.to/3NHXtIb
Elgato Facecam: amzn.to/3F1Cagk
TC Helicon Mixer: amzn.to/3TbTmoZ
RGB keyboard: amzn.to/3MGytiL
2k Gaming monitors: amzn.to/3vYb7OP
Switch: amzn.to/372aYl8
Microsoft 365 Family: amzn.to/38H85qc
Microsoft 365 Business: amzn.to/3OSDQO2
My name is Excel - troubleshooting: amzn.to/3vVBPb1
The Definitive Guide to DAX: amzn.to/376c7s2
Prime Student 90 days free: amzn.to/3MJ8LKw
============ R I S O R S E ====================
DOWNLOAD for "Student Plus" or higher: drive.google.com/file/d/1tLEz...
Channel index - Available to subscribers only: docs.google.com/spreadsheets/...
LINK: www.sqlbi.com/articles/compar...
Lesson Chapters:
1. Introduction 0:00
2. Example with classic Excel formulas 0:58
3. We import the table from Excel into Power Pivot 2:28
4. How I create a Calculated Field 3:02
5. How do I create a Measure 3:52
6. Two-Dimensional Pivot 6:58
7. Let's see how the Calculated Fields and Measures 7:26 work
8. Calculated Fields in Power Pivot or in Power Query 18:27
9. Greetings 24:33
#PowerBiExcel #Dax #PowerPivot #Calculated Fields #MeasuresDax
Негізгі бет What are Calculated Fields and Power Pivot Measures
Пікірлер: 40