VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
How to use Power BI DAX - Kevin Stratvert

How to use Power BI DAX - Kevin Stratvert

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
How to use Power BI DAX - Kevin Stratvert 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
Date: 2022-03-15

Comments and reviews: 10


My ur forine m tok soings morie laitire my eaire trck it u tok soingis my mamori caris it coimpilit ur b u sidie loike it my lifie dramigse friste noiwe my laitre my harinde trck it laitre my tok soingis trck it ur b aimagin u tok soingis noite showr u my tok it u hed phainye my drainage
reply

Hi Kevin, another great video as usual;) - however, like someone already pointed out on the comments below (Jonathan Porter), there's a mistake on the bar chart - Orders should add up to 700 but they are not. This is because the Values field should be summarised by Count. Cheers
reply

Hi Kevin, you did amazing on this video.
I do have a doubt on your explanation on the differences between iterator and aggregate functions.
Aggregator do also go through row by row (parameters we've selected) for the calculation isn't it ? help me with it

reply

As always i have learnt alot from you, Kevin. Just 1 thing to check under Calculate. I am not clear why you use double equal sign (i.e. product not equal choc chip) when you are trying to measure chocolate chip with more than 500 units. Thanks so much!
reply

hi, thanks for the video.
would you please to help me understand more clearly why it appears to have a table 3 and and -order- when getting data. what if i chose table 3 instead of the -order-? what is the difference? thank you.

reply

Does Power BI have a concept of -analysis files- just as we do in Spotfire? Where the visuals and data is all stored in a file that is offline. Users can access that file offline any time without needing the data source.
reply

I've completed the introduction video, now I'm watching this. What more do I need to learn for complete knowledge about the Software ? Can you suggest regarding this
reply

Thank you very much for your video but may I ask if you can check again the value of Total Profit 2 and Total Profit measures? they seems to be different slightly
reply

Boy, did Microsoft loose a great employee when you left the company.....
You are the best teacher - no doubt about that.
Thank you for your great vids !!!

reply

Omg, you are the BEST teacher I have ever encountered. I don't think I ever thought I could be so grateful to someone I've never even personally met, thank you!
reply
Add a review, comment






Other channel videos