Hellow guys, Welcome to my website, and you are watching π How to use Power BI DAX - Tutorial. and this vIdeo is uploaded by Kevin Stratvert at 2021-05-17T00:00:29-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | π How to use Power BI DAX - Tutorial |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 17-05-2021 07:00:29 |
| Video Discription | In this step-by-step tutorial for beginners, learn how to use DAX (Data Analysis Expressions) in Microsoft Power BI. DAX is a formula language with functions. If you've ever written formulas in Excel, you'll find that DAX is very familiar. We'll start by loading the sample data into a data model. Next, we establish relationships between the various tables. Once the setup is complete, we'll write our first measure. A measure is a calculation that runs across our data model. You'll learn about a few different functions, including sum and count. You'll also learn how to comment your expressions. Next, we create a measure using operators, like addition, subtraction, division, and multiplication. We then dive into how you can create measures using a graphical user interface called Quick Measures. We then move onto creating a calculated column and talk about the advantages and disadvantages of columns vs. measures. We then dig into iterator functions and when you would use them compared to an aggregator function. Iterator functions include sumx, countx, averagex, maxx, minx, and rankx. Next, we look at the date functions that are available and we use the one called weekday. We wrap up by looking at some logical functions, including find, if, and calculate. π Additional resources - Introduction to Power BI (Start here if you're new to Power BI) - https://youtu.be/TmhQCQr_DCA - Sample files (use these to follow along) - https://1drv.ms/u/s!AmxrofZZlZ-whMIgS9WJS7BwSfHBbw?e=0z3nQn β Timestamps 0:00 Introduction 0:49 Import data & create data model 3:25 Define relationships 5:14 Create new measure using sum function 10:22 Format measures 11:44 Edit & delete measures 12:33 Create new measure using count function 14:30 Create new measure using distinct function 16:02 Add comments to measures 16:56 Create new measure with operators 19:08 Quick Measure tool 20:36 Create calculated column 21:38 Measure vs. calculated column 22:07 Measure that references another measure 24:19 Iterator functions 27:32 Time & date functions 30:12 Find function 32:38 If function 33:54 Calculate function 36:39 Wrap up π Watch related playlists - Playlist with all my videos on Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe π© NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ π© Connect with me on social - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://discord.gg/kHuujY2pZf - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ π Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?sub_confirmation=1 π¬ Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com π Support me with your Amazon purchases: https://amzn.to/3kCP2yz β As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert |
| Category | Science & Technology |
| Tags | kevin stratvert | power bi | power bi tutorial for beginners | tutorial | beginners | microsoft power bi | microsoft | power bi tutorial | how to use power bi | powerbi | power bi for beginners | microsoft bi | microsoft power bi tutorial for beginners | what is power bi | ms power bi | power bi basics | dax | data analysis expressions | formula | function | functions | formulas | how to use power bi for beginners | how to | introduction | power query | dashboard | using power bi | bi | power | powerbi tutorial | learn |
