PowerPivot - DAX Studio for Excel
34th Lesson
In this lesson we will install DAX Studio and connect with it to Excel's PowerPivot data model. We will learn how to run queries to simplify the process of building complex formulas.
=========== S O S T I E N I M I ==================
Subscribe to this channel to access the benefits: / @lodovicodincau
Buy a product: https://lodovicodincau.myspreadshop.it/
Donate: https://www.paypal.com/donate/?cmd=_d...
======= SAFE AND AFFORDABLE SOFTWARE! ==
Office, Windows, Antivirus, VPN, Server: https://mrkeyshop.com/it/?MrKey=484
======= MY EQUIPMENT ===============
Mouse: https://amzn.to/3s1XwF2
Yeti microphone: https://amzn.to/3MDCggU
Microphone without stand: https://amzn.to/3LAoWcS
Yeti filter: https://amzn.to/3KwKAO2
Sony Alpha 6400L: https://amzn.to/3t5cN8u
Elgato Stream Deck: https://amzn.to/3NDf0RM
Elgato Cam Link 4K: https://amzn.to/3NHXtIb
Elgato Facecam: https://amzn.to/3F1Cagk
TC Helicon Mixer: https://amzn.to/3TbTmoZ
RGB keyboard: https://amzn.to/3MGytiL
2k Gaming monitors: https://amzn.to/3vYb7OP
Switch: https://amzn.to/372aYl8
Microsoft 365 Family: https://amzn.to/38H85qc
Microsoft 365 Business: https://amzn.to/3OSDQO2
My name is Excel - troubleshooting: https://amzn.to/3vVBPb1
The Definitive Guide to DAX: https://amzn.to/376c7s2
Prime Student 90 days free: https://amzn.to/3MJ8LKw
============ R I S O R S E ====================
Channel index - Available to subscribers only: https://docs.google.com/spreadsheets/...
Lesson Chapters:
1. Introduction 0:00
2. Download and install DAX Studio 0:48
3. Connect to Excel PowerPivot 1:56
4. Query Builder 4:32
5. Let's look at the formula of a measure 7:38
6. Let's enter a query 8:41 into DAX Studio
7. We run the query in DAX Studio 11:06
8. Pay attention to punctuation 1:05 pm
9. Greetings 2:14 pm
#DaxStudio #PowerPivot #Excel