📊 How to use Power BI DAX - Tutorial

Ғылым және технология

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) - • How to use Microsoft P...
- Sample files (use these to follow along) - 1drv.ms/u/s!AmxrofZZlZ-whMIgS...
⌚ 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: • Power BI
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🚩 Connect with me on social
- LinkedIn: / kevinstratvert
- Discord: / discord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🔔 Subscribe to my KZread channel
kzread.info?...
🎬 Want to watch again? Navigate back to my KZread channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: 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

Пікірлер: 641

  • @KevinStratvert
    @KevinStratvert3 жыл бұрын

    🙋🏻‍♂️ New to Microsoft Power BI? Get started with this introductory video: kzread.info/dash/bejne/hqGcs6WKosKqc6Q.html

  • @Learun478

    @Learun478

    3 жыл бұрын

    Please teach about data flow and M language . Thank you kevin

  • @jagatkrishna1543

    @jagatkrishna1543

    2 жыл бұрын

    Great 👍😊🙏💕

  • @thenvrdiaries8169

    @thenvrdiaries8169

    Жыл бұрын

    Kevin, would really appreciate if you could guide me on ho wI can use PowerBI, SQL and Toolpak on Macbook

  • @sayedjawadali

    @sayedjawadali

    Жыл бұрын

    can you please add xls link of all 3 exercise file ?

  • @balogunolajide7204

    @balogunolajide7204

    8 ай бұрын

    I’ve watched several tutorials on Dax but yours stands out more and straight to the point. Thanks Kelvin

  • @walkernationz1743
    @walkernationz1743 Жыл бұрын

    Today I went to a work interview (Thursday). They asked me if I was good on Power BI, and I never heard about it before. They said they could get around it, but I said I would be able to master it by Monday. Your videos popped up on my search and as I followed them, I feel like I'm ready in just one day. Really nice, powerful and simple at the same time program. Thanks to your tutorials, the introduction to this program was easy for me. Keep up with these videos. You will be the first search going on from here for software tutorials for me.

  • @joanneosborne2428
    @joanneosborne24282 жыл бұрын

    Kevin, you are such a great teacher. 🤩Thank you for keeping it very simple and clear. I love the way you explain everything and I am excited to watch more of your training videos for DAX. I have found Dax hard to learn but you make it fun and exciting. 😀

  • @ShoOnlineAcademy

    @ShoOnlineAcademy

    6 ай бұрын

    Do you know the different between power BI vs. Power Query?

  • @nevkarngutor2122
    @nevkarngutor2122 Жыл бұрын

    What a great teacher. You just made DAX look less of a mystery to me. never thought I will take on DAX and be this happy. Thank you Kevin. God bless you Sir

  • @michelleliu1181
    @michelleliu1181 Жыл бұрын

    Thanks very much for this! It's been a while since I last used Power BI DAX functions and needed a refresher. Your video turned out to be so much better than what I had initially expected! I hope you can do more tutorials on complicated DAX, they used to give me so much headaches!

  • @gajabathiarjuntg2390
    @gajabathiarjuntg23903 жыл бұрын

    I am absolute beginner in Power BI Dax formulas. But now by watching this video I understood how to use them and about their core functionalities. Thanks Kevin great effort.

  • @KevinStratvert

    @KevinStratvert

    3 жыл бұрын

    Glad it was helpful!

  • @accountinganalyticsacademy5615

    @accountinganalyticsacademy5615

    Жыл бұрын

    It is usually tough to start gradually you will get a hand of it. Think about it, as if you are in excel. I tried to make a video on DAX for beginners.. kindly check it out...

  • @carelkawele2915
    @carelkawele29152 жыл бұрын

    Kevin, I just started a job at an accounting firm and we use Power BI as a tool during audits. This is amazing really. Great work explaining every step, it's extremely helpful!

  • @accountinganalyticsacademy5615

    @accountinganalyticsacademy5615

    Жыл бұрын

    Hi Carel! Please what are some of the use Cases in using Power BI for Audit....? Thanks ...

  • @shmulyseligson

    @shmulyseligson

    11 ай бұрын

    How do you use power bi for audits? I’m curious because I was actually wondering if there was applications for using power BI in the finance industry.

  • @corporatemonks7988
    @corporatemonks79883 жыл бұрын

    This is fantastic, I had basic idea about power BI and DAX... but this video helped me to get into detail on calculation part... It was easy to understand and learn. Thanks a lot 🙂

  • @manhthinhbui1545
    @manhthinhbui15457 ай бұрын

    Kevin, you are such a great teacher! I've spent 3 months learning from some other guys on KZread and doesn't understand anything. But your 37-min video just changed anything, I could understand a bit more on how star scheme, DAX, new colume, measure,... works. That's just great!

  • @BlushStix
    @BlushStix3 жыл бұрын

    It's Amazingggggggggg! The way you've explained just makes me wanna learn more. We need more videos on DAX please!

  • @dexxxxxxxx

    @dexxxxxxxx

    2 жыл бұрын

    Hey, I'm EC engineer... Can I learn Power BI? Which language or software I should learn alongside power BI? what is job opportunity for freshers in india? Please guide.... 🙏🏻

  • @BlushStix

    @BlushStix

    2 жыл бұрын

    @@dexxxxxxxx Hey sure. You can learn power BI. You don't need to learn any additional software, however it's recommended to learn Excel (if not learnt). You'll be good to go.

  • @dexxxxxxxx

    @dexxxxxxxx

    2 жыл бұрын

    @@BlushStix thank you ma'am... How much salary fresher can earn with power BI?

  • @BlushStix

    @BlushStix

    2 жыл бұрын

    @@dexxxxxxxx A power BI developer can earn anything between 3.5lac to 10lac in India. You need to have knowledge about Fax when you'll learn power BI, make sure DAX is included in it.

  • @dexxxxxxxx

    @dexxxxxxxx

    2 жыл бұрын

    @@BlushStix that's appealing salary... 🤯 Thank you very much for information 🙏🏻

  • @nielporter3765
    @nielporter3765 Жыл бұрын

    Kevin, this instruction is awesome. I'm pretty new to Power Bi but I've been performing data analysis for a long time. Your instruction touched on many topics that quickly made sense to me (leveraging my previous experience with Excel) and the examples (following along with your example files) cleared up any questions I had. I only wish I had Power Bi 30 years ago (yes, I'm old). Thank you.

  • @deldridg

    @deldridg

    Жыл бұрын

    That means I must be old too. Perhaps better to say that you are experienced (or even highly experienced)! Cheers - Dave

  • @kemad86x
    @kemad86x2 жыл бұрын

    Nice video. Very descriptive with good examples. I would have loved it if, when you were doing % and margins, you showed how big a % of total profits each customer was. So the customer profit % of total profit, and in the same table. That would have been a great real world addition 😊

  • @petruswahjudi1119
    @petruswahjudi11192 жыл бұрын

    Kevin, you are a great teacher. You explain very details and clear. Thank you for sharing your knowledge.

  • @jasminjavia6445
    @jasminjavia644511 ай бұрын

    Each time I saw your tutorials...I end up watching your video by saying you a big thank you from the bottom of my heart...it is really helpful Kevin...you are truly great teacher...thanks once again.

  • @chernormajujalloh9680
    @chernormajujalloh96803 ай бұрын

    Thank you Kevin 👍🏻 I’m a final year student student studding Business IT. Data analyst and science are my career path I’m considering cause I’m efficient in excel, sql and a beginner in python language. Your power BI tutorial is a top notched for me. I got a job interview recently for a data analyst role. After having gone through your tutorials over the past few months, I stood out during the interview and the panelists were impressed. The only challenge I had was that I’m yet to complete my course but I believe after I’m done I will get one in that area. 👍🏻👍🏻👍🏻

  • @shoaibazizmeer
    @shoaibazizmeer Жыл бұрын

    Hey Kevin! Now I finally understand the difference between aggregate functions and iterate functions. Two thumbs up to you.

  • @Shazlys
    @Shazlys3 жыл бұрын

    This was awesome!! We need more advanced Power BI videos.

  • @TomiwaAdegbola
    @TomiwaAdegbola2 жыл бұрын

    This video summarizes what took me 1 month to learn from DAX pdf book. Great work Kevin! Thanks for this!

  • @karthikganapathy9966
    @karthikganapathy9966 Жыл бұрын

    Thanks a lot Kevin! I keep coming back here for the DAX measures using your cookie examples. Makes it so easy to understand. Power to you!

  • @Lucyliuyu
    @Lucyliuyu2 жыл бұрын

    Thank you Kevin!! You are a great teacher! I am new to Power BI. You have a very clear explanation and it's easy to follow. I hope to continue see your videos and learn from you. Thank you for sharing your knowledge!!

  • @animespartan8218
    @animespartan82182 жыл бұрын

    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!

  • @marymurathi164
    @marymurathi1643 жыл бұрын

    Kevin you are just amazing ! Thank you so much for profound and comprehensive tutorial. I'm grateful

  • @marcusmacmillan8949
    @marcusmacmillan89499 ай бұрын

    Thank you so much Kevin! I have been struggling a bit with some of these concepts in DAX and this has made everything so much clearer for me. I can't wait to go back and rewrite some of my old measures and create new more powerful ones, especially with the Calculate Function.

  • @braunmar7
    @braunmar72 жыл бұрын

    Really useful, thank you!! I like that I can follow along with the sample files real time. Love the format!

  • @DevanshuB
    @DevanshuB Жыл бұрын

    Hey Kevin, great stuff! You have made it really easy to understand Power BI. I would love to see more videos on Power BI which cater to the advanced crowd.

  • @breezyiusmaximus2735
    @breezyiusmaximus273510 ай бұрын

    Thanks for the walk through and taking some of the guess work out of getting started with PBI…you explain all the little details very well and make it easy to understand! 🙏

  • @aruzhanmuratbeck5840
    @aruzhanmuratbeck58402 жыл бұрын

    Thank you so much! The video is very structured and easily understandable. I’ve enjoyed learning Power BI with you. Please upload more video on it :)

  • @Maheshpanduranga1986
    @Maheshpanduranga19863 жыл бұрын

    Kevin, you really mastered every product of Microsoft...very nice session. Thanks

  • @dexxxxxxxx

    @dexxxxxxxx

    2 жыл бұрын

    Hey, I'm EC engineer... Can I learn Power BI? Which language or software I should learn alongside power BI? what is job opportunity for freshers in india? Please guide.... 🙏🏻

  • @maximpiras
    @maximpiras2 жыл бұрын

    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

  • @masoumehrahmani9155
    @masoumehrahmani91552 жыл бұрын

    You are a true teacher Kevin, Thanks for clear explanations

  • @luffygear5362
    @luffygear5362 Жыл бұрын

    Your videos are the cleanest, neatest and smoothest videos anyone can ever come across. Hats off to your hard work!

  • @JerryvanRosado
    @JerryvanRosado2 жыл бұрын

    Great video, I really enjoyed watching it. I'm on day 2 of my new Manager of People Analytics position, and this came in super handy. Thank you, Kevin.

  • @riccalewis4483
    @riccalewis44832 жыл бұрын

    the expression formula is rather complex but the whole presentation was really insightful/articulated and easy to follow! Well done

  • @Brothercole1994
    @Brothercole19943 жыл бұрын

    Kevin. You're a legend! Thank you for this. Hands down best DAX tutorial. Going to watch again and follow through with the files you provided.

  • @KevinStratvert

    @KevinStratvert

    3 жыл бұрын

    Thanks for the note BrotherCole 94! Much appreciated 👍

  • @AvanishKesharwani
    @AvanishKesharwani3 жыл бұрын

    Kevin, I was not knowing what Power BI is, but due to you I now understand how powerful the Power BI is. Really, Great Thanks to you and your work :-) 👍👍

  • @KevinStratvert

    @KevinStratvert

    3 жыл бұрын

    Glad to help!

  • @cajithingeorge
    @cajithingeorge Жыл бұрын

    you are a special teacher/tutor. easy and simple to understand. Thanks man for your valuable contribution

  • @owolojarufusadeyo9843
    @owolojarufusadeyo98432 жыл бұрын

    Kevin, you are simply Amazing man! The simple practical way you explain all the steps makes it really easy 5o follow and understand. Thanks for sharing your knowledge....l hope to continue learning new things on Power BI and DAX from you...and other topics. Thank you again Kevin!

  • @Mr.X-ur1we
    @Mr.X-ur1we8 ай бұрын

    Thank you, Kevin. You explained DAX in a lucid way.

  • @mangalabandaranayake3150
    @mangalabandaranayake31507 ай бұрын

    Dear Kevin, your lessons are easy to follow and undestand. Keep up good work.

  • @farheendabir5558
    @farheendabir5558 Жыл бұрын

    Awesome video. This is just what I needed to understand DAX. No nonsense, straight to the points. :)

  • @sojolhamid6356
    @sojolhamid63562 жыл бұрын

    Your explanation is simple & easy to grab! Thanks for your initiative!

  • @simonlacey70
    @simonlacey703 жыл бұрын

    Another great tutorial from Kevin Stratvert! Thanks Kevin

  • @nonoobott8602
    @nonoobott86023 жыл бұрын

    Absolutely amazing video. Very explicit. You make it so easy to follow and understand. Thanks for sharing

  • @pushkalvashist3637
    @pushkalvashist36373 жыл бұрын

    Thanks a lot Kevin! Love from Singapore 🇸🇬

  • @vishg.1533
    @vishg.15334 ай бұрын

    Thank you so much for this, after taking so many courses still i wouldn't able to learn, but after watching this I'm pretty sure that little little things make you smarter, That's why I have completed my all doubts here. You saved me man. If anyone wanna learn powerbi do watch this before started cuz this small steps help you alot❤

  • @jesusz1499
    @jesusz14993 жыл бұрын

    Excellent so much knowledge in such a short time and wonderfully explained, thank you very much.

  • @olamideo2453
    @olamideo24532 жыл бұрын

    Thank You Kevin, awesome teacher. Please making more videos. I appreciate all you do.

  • @ogonnachinwike9024
    @ogonnachinwike90242 жыл бұрын

    Fantastic job. You are a natural teacher, thank you.

  • @jagdish4523
    @jagdish45232 жыл бұрын

    A powerful dose of knowledge with so ease. Thank you Kevin

  • @makarand1985
    @makarand1985 Жыл бұрын

    Mr. Kevin you are the King !!!! Thanks for all your guidance SIR !!!

  • @BilalKat
    @BilalKat2 жыл бұрын

    Excellent video Kevin! Gives a high level overview and introduces many of the major concepts, without getting too bogged into any one concept.

  • @dexxxxxxxx

    @dexxxxxxxx

    2 жыл бұрын

    Hey, I'm EC engineer... Can I learn Power BI? Which language or software I should learn alongside power BI? what is job opportunity for freshers in india? Please guide.... 🙏🏻

  • @BilalKat

    @BilalKat

    2 жыл бұрын

    @@dexxxxxxxx Hi and thanks for your question. Power BI is a small part of a massive and very lucrative field, which is Data Warehousing and Business Intelligence. With the rise of big data, BI has become a high-demand career. So, yes - there are lots of jobs available. You can choose to focus just on Power BI or focus on BI in general, Data Warehousing or Dimensional Modelling.

  • @ahmedaliiiii
    @ahmedaliiiii2 жыл бұрын

    Brilliant ! i just finished the whole power BI playlist. i hope to add more advanced videos.

  • @sumandeep5553
    @sumandeep5553 Жыл бұрын

    Explained in a short, simple, and impressive way ..... Great video

  • @cq7499
    @cq74992 жыл бұрын

    Thank you so much for the tutorial! It literally taught me a lot!

  • @karthicr6568
    @karthicr65682 жыл бұрын

    Good one. You were clear in explaining the DAX functions. Thank you

  • @jeffpeake4130
    @jeffpeake41303 жыл бұрын

    Great video. I really enjoy your style of explanation. I also greatly appreciate the sample files so I can follow along.

  • @andreaforen6498
    @andreaforen6498 Жыл бұрын

    Great tutorial, much appreciate the sample data files to be able to follow along!!

  • @TheKanand
    @TheKanand2 жыл бұрын

    One of the Best DAX class in KZread. ! Very helpful .. Keep teaching !!

  • @dexxxxxxxx

    @dexxxxxxxx

    2 жыл бұрын

    Hey, I'm EC engineer... Can I learn Power BI? Which language or software I should learn alongside power BI? what is job opportunity for freshers in india? Please guide.... 🙏🏻

  • @akmalzolkepli7028
    @akmalzolkepli70283 жыл бұрын

    Kevin !! You are awesome. It was superb explanation and the pace is just nice for us to digest. Good work !!

  • @kirillperian
    @kirillperian2 жыл бұрын

    Nicely done, Kevin! On your Day of the Week part of the video, you are adding them (instead of adding Orders) and slicing by Days of the Week as well in that visual.

  • @w.hernandez5829
    @w.hernandez58292 жыл бұрын

    Wonderfully taught and very easy to follow! 😀

  • @sayonsarkar1075
    @sayonsarkar10752 жыл бұрын

    Great tutorial Kevin, just loved it. Also, can we get the datasets/ excel files used in this tutorial? it will help us to do the hands-on simultaneously along with watching the video. Thanks in advance!

  • @Askyvonnew
    @Askyvonnew2 жыл бұрын

    Excellent tutorials -- thanks Kevin! Wish you could do some more!

  • @akeen2k
    @akeen2k3 жыл бұрын

    Thanks Kevin. Your sharing is very straight forward and useful. Much appreciated!

  • @PatrickWallet
    @PatrickWallet2 жыл бұрын

    Kevin, thanks for this DAX tutorial. Very clear explained!

  • @user-bz6si1vk8e
    @user-bz6si1vk8e Жыл бұрын

    Thank you Kevin. you are such a great teacher :) i always thought DAX will be hard to learn.. but your explanation made me to understand easily. 😀

  • @himayeldo7920
    @himayeldo79202 жыл бұрын

    Thank you for making this video. I almost learned everything and you made it very easier for us to understand. I expecting some more videos from you on dax expression.

  • @atanshichaturvedi492
    @atanshichaturvedi4923 жыл бұрын

    This tutorial is very helpful. Thanks Kevin ! Other tutorials on DAX is not even close to this one.

  • @sanjayadsure
    @sanjayadsure2 жыл бұрын

    Thank you Kevin, we really need more videos on DAX

  • @jsaonresh4141
    @jsaonresh41413 жыл бұрын

    Just getting started with using power bi and this video was really helpful. I able to create a dashboard after watching it! Thanks!

  • @JM-mb6tf
    @JM-mb6tf2 жыл бұрын

    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 !!!

  • @45sdk
    @45sdk2 жыл бұрын

    @Kevin, this was super helpful. Can you please make more detailed videos covering the various scenarios where DAX can be used?

  • @accountinganalyticsacademy5615

    @accountinganalyticsacademy5615

    Жыл бұрын

    Hi Rahul! I tried to make some videos on DAX for beginners.. kindly check it out if helps...

  • @mikeyork8587
    @mikeyork85872 жыл бұрын

    Very, very well done! I make "how to" instructional videos for the large school system I serve and I know from experience how challenges these can be to make look so smooth. I learned a lot, want to put what I learned into practice and learn even more!

  • @user-pl1ky4um8w
    @user-pl1ky4um8w3 ай бұрын

    Emil Egiazarian It was very professional and main thinks you was acting like a good teacher, i am college professor my self and like to learn Power bi i will follow all your lessons. Thank You so Much

  • @ramizmalek7090
    @ramizmalek70902 жыл бұрын

    @kevin, When you use the table Cookie Types for calculating a profit to which your named as Total Profit 2, applying the measures, it shows profit as 2717064.38. But, the moment you tick mark the column "Name" along with Total profit 2, it shows the same figures for all the names which was not the case in the earlier profit you had calculated.

  • @hamnaanwar3651

    @hamnaanwar3651

    Жыл бұрын

    hello, did you figure out the issue? im facing the same problem

  • @tubez29
    @tubez293 жыл бұрын

    Well done Kevin! You showed great examples using DAX. Please add another more advanced course.

  • @KevinStratvert

    @KevinStratvert

    3 жыл бұрын

    Thanks, will do!

  • @simonb7556
    @simonb7556 Жыл бұрын

    What a great tutorial. Very clear explanations. 10 out of 10.

  • @jonathanporter7601
    @jonathanporter76012 жыл бұрын

    For the bar chart of the weekdays at around 29:55, the values add up to over 700 (greater than the number of rows in the data). To correct this issue, in my version of Power BI, for the bar chart, I had to select "Count of Day of Week" in "Values" and then place "Day of Week" in "Axis". Thanks so much for your work Kevin! I appreciate your clear overview.

  • @maximpiras

    @maximpiras

    2 жыл бұрын

    I spotted the same and left another comment;)

  • @thefamousdjx

    @thefamousdjx

    2 жыл бұрын

    Day of week vs Count of Day of Week? That still wont mean anything. It should have been Day of Week vs Units Sold.

  • @spolohsu

    @spolohsu

    6 ай бұрын

    I think it should be count of order id

  • @mensurcehic413
    @mensurcehic413 Жыл бұрын

    Excellent training technique. Very methodical and to the point.

  • @asalfarahani3061
    @asalfarahani30612 жыл бұрын

    Thank you so much for such a good training . I hope you keep on making such videos for power BI .

  • @venkatareddykummitha5863
    @venkatareddykummitha58633 жыл бұрын

    I am a non-background computer knowledgeable person. But this is an Awesome practical explanation with a live show. I love practical knowledge in a simple way first. I just love it. FINALLY, I FOUND THE BEST ONE FOR ME. DO MORE VIDEOS ON DAX FUNCTIONS FROM EASY TO ... .. DEPTH(MAINLY ON-TIME INTELLIGENCE )

  • @KevinStratvert

    @KevinStratvert

    3 жыл бұрын

    More to come Venkatareddy!

  • @accountinganalyticsacademy5615

    @accountinganalyticsacademy5615

    Жыл бұрын

    Hi venkatreddy ! I tried to make a video on DAX for calendar table for beginner which will help in time intelligence.. kindly check it out...

  • @rena232
    @rena232 Жыл бұрын

    Hi Kevin, thanks for this awesome video! It helps me quickly start with Power BI! However, I found the analysis of the order number by the day of the week was wrong. The Y-axis you did in the video was SUM (the default function was SUM), so the value equals the day number times the order number. It should be changed to Count.

  • @samkol202
    @samkol2022 жыл бұрын

    All I can say is thank you for this! I understand everything now

  • @olaniyanyusuf9648
    @olaniyanyusuf96482 жыл бұрын

    This is well explanatory and easy to follow. Good job!

  • @excelworx8712
    @excelworx87122 жыл бұрын

    Thanks Kevin, that was very insightful. Please lobby with Microsoft to make all these measures available in Quick Measures

  • @baleani1955
    @baleani19552 жыл бұрын

    Thank you Kevin, you are amazing. No confusion at all

  • @kamrankhalid5180
    @kamrankhalid5180 Жыл бұрын

    very well explained. I watched two of your videos on power bi and they covered a lot of topics and I got a good handle on them. thanks for your wonderful teaching skills and your command over power bi.

  • @pradumnsanthalia554
    @pradumnsanthalia5542 жыл бұрын

    Thanks, Kevin. You've explained really well!

  • @BaddieStation
    @BaddieStation2 жыл бұрын

    You're amazing. i was hoping to find more videos on your channel on Power BI. You do a good job at teaching.

  • @lolaadeoye3584
    @lolaadeoye35842 жыл бұрын

    Thank you very much for sharing your knowledge, I'm getting stronger with Power BI

  • @rizzrak
    @rizzrak Жыл бұрын

    Very straightforward and helpful!

  • @Life-tech-hack-103
    @Life-tech-hack-1032 жыл бұрын

    This is a very useful video on dax! Thanks for making it simple to understand

  • @9praveenmaddi
    @9praveenmaddi Жыл бұрын

    One of the best videos on DAX. Thanks Kevin

  • @wordworship8660
    @wordworship8660 Жыл бұрын

    Blessings from Colombia friend. Wonderful tutorial Thanks so much for sharing! You got a new subscriber!

  • @adebolaolayode8399
    @adebolaolayode83992 ай бұрын

    Kelvin, thank you for this tutorial. You are a great teacher, very detailed and concise. I should be able to use this for my case study.

  • @aynellrodriguez7348
    @aynellrodriguez73482 жыл бұрын

    Needless to say, this was incredebly helpful. Thanks!!

  • @syedatasneemfatima7062
    @syedatasneemfatima70623 жыл бұрын

    Crisp, clear, very informative, thanks

  • @shmulyseligson
    @shmulyseligson11 ай бұрын

    Another excellent video! Thank you for all your wonderful content. These videos really make my learning process so much easier. I appreciate all the effort you put into these videos.

  • @JennaNeal
    @JennaNeal2 жыл бұрын

    This was awesome. You have a perfect pace that draws attention. Great job. Thank you.

  • @gloriyathomas
    @gloriyathomas2 жыл бұрын

    One of the best DAX intro tutorial, Thanks a lot!

Келесі