Power BI DAX Tutorial - Beginner to Advanced [Full Course]

Поділитися
Вставка
  • Опубліковано 20 чер 2024
  • Learn DAX from scratch in this comprehensive tutorial!
    DAX is a powerful language that allows you to create custom calculations and measures in Power BI. It's essential for any data analyst or Power BI developer to know how to use DAX effectively.
    This video will teach you everything you need to know about DAX, from the basics to more advanced topics. We'll cover the following:
    Data Used :
    www.pivotalstats.com/post/com...
    Timecodes
    0:00 - Overview
    1:02 - Introduction to DAX
    8:36 - Date & Time DAX 1 - Calendar & CalendarAuto
    13:44 - Date & Time DAX 2 - Date, DateDiff, DateValue
    21:05 - Date & Time DAX 2 - Now, Today, Day, Edate, EOMonth, Networkdays, Weekday
    29:53 - Aggregate DAX - Sum, Count, Average, X Functions, Distinct
    39:23 - Logical DAX - If, IfError, And, Or
    47:12 - Text DAX - Upper, Lower, Concatenate, Len, Left, Right, Mid, Replace, Substitute, Search
    57:36 - Filter DAX - Calculate, All
    1:05:18 - Relationship DAX 1 - Related
    1:10:50 - Relationship DAX 2 - Related vs. RelatedTable
    1:18:27 - Relationship DAX 3 - Crossfilter
    Microsoft DAX Learning - learn.microsoft.com/en-us/dax/
    Excel Switch Function : • Why do we need SWITCH ...
    Affiliate Links --
    Best Web Hosting Service :
    bluehost.sjv.io/k0OkNv
    Cool tech that I use for these videos :
    1. Blue Yeti Microphone - amzn.to/43FEYdT
    2. LG Ultrawide Curved Monitor - amzn.to/3rEMsR7
    power bi dashboard,power bi,power bi dashboard tutorial,power bi tutorial,power bi dashboard design,power bi tutorial for beginners,power bi for beginners,microsoft power bi,learn power bi,sales dashboard in power bi,power bi training,power bi desktop,how to create dashboard in power bi,power bi reports,power bi project,power bi dashboards,power bi report,power bi kpi dashboard,dashboard in power bi,how to power bi,power bi dashboard examples

КОМЕНТАРІ • 100

  • @OluwaseunK
    @OluwaseunK 4 місяці тому +1

    This is such an explicit coaching, thank you for every bit of explanation. It has helped a great deal

  • @azzurikayvo
    @azzurikayvo 2 місяці тому

    clear and straight to the point.A well done tutorial.

  • @infusionchurchmd
    @infusionchurchmd 2 місяці тому

    Absolutely loved this masterclass!

  • @rasiksawant7491
    @rasiksawant7491 12 днів тому +1

    This is absolutely the best DAX tutorial.

    • @pivotalstats
      @pivotalstats  12 днів тому

      Thankyou so much, glad u liked it !

  • @tyronefrielinghaus3467
    @tyronefrielinghaus3467 5 місяців тому +8

    Fantastic...best DAX explanation ever. Step by step. No waffle. No confusion. Screenshotted the fax categories very early on in the video. Thanks so much.

    • @pivotalstats
      @pivotalstats  5 місяців тому

      Awesome, thanks for watching!

    • @sunnyboy6433
      @sunnyboy6433 4 місяці тому

      I have found your explanation easy to follow, using straightforward examples and your approach method to break down complex DAX is much appreciated.

  • @hemantkumarchaurasia722
    @hemantkumarchaurasia722 Місяць тому +1

    This is the best dax tutorial ever seen on youtube. Hope that more useful content will be shared by the Pivotalstats🙏

    • @pivotalstats
      @pivotalstats  Місяць тому

      Much appreciated! Will definitely try my best :)

  • @MAG.experiences
    @MAG.experiences 23 дні тому +1

    One of the best videos on DAX on UA-cam.

  • @parthtandel5848
    @parthtandel5848 4 місяці тому

    Loved the way you explain and presented !!! Keep bringing such valuable content.

  • @gustavopineda7933
    @gustavopineda7933 5 місяців тому +1

    I really liked the presentation and effects of the video, very good work and also the very interactive teaching.

  • @jayxpea
    @jayxpea 7 місяців тому

    This was a VERY good introduction video. Really appreciate the content

  • @sakshikothari7689
    @sakshikothari7689 5 місяців тому +4

    Amazing content and delivering. You have made every concept simple to understand. Thank you for such great explanations. Keep posting insightful videos like this, they are really helpful.

  • @chinmayrane60
    @chinmayrane60 3 місяці тому

    Very well explained.
    Thank You..

  • @MoeBig50
    @MoeBig50 Місяць тому

    Wonderful video I have been working with BI for over a year now and I learned alot from your videos.

    • @pivotalstats
      @pivotalstats  Місяць тому

      Great to hear! Thanks for watching :)

  • @anillpatel
    @anillpatel Місяць тому

    Awesome video presentation.
    Excellent working examples.
    Thank you...,

    • @pivotalstats
      @pivotalstats  Місяць тому +1

      You are Welcome, thanks for watching!

  • @gospelmoto2833
    @gospelmoto2833 7 місяців тому

    Wow! useful. Thanks for sharing.

  • @karanladla4911
    @karanladla4911 4 місяці тому

    One of those videos which is going to be helpful almost everytime we'll work on P-BI.
    Thanks Sajit.

    • @pivotalstats
      @pivotalstats  4 місяці тому

      Glad to hear that. Thanks for watching!

  • @myfuture1164
    @myfuture1164 6 днів тому

    Super se Upper Power Bi DAX . Thank You for Providing Dax !!!

    • @pivotalstats
      @pivotalstats  5 днів тому

      My pleasure, really glad you liked it!

  • @akshaykhobragade8494
    @akshaykhobragade8494 2 місяці тому

    i looked many videos but found this is the best. what an explaination, clear concept, no confusion, short notes are very valuable, and i also appreciate your preffered techniques. thankyou for such amazing and valuable content video

    • @pivotalstats
      @pivotalstats  2 місяці тому

      Thank you for the appreciation. Really glad that it helped! 🙂

  • @oukiebotha2227
    @oukiebotha2227 2 місяці тому

    The best DAX tutorial. Many thanks. Much appreciated....Thank you..Thank you..🙏🙏🏆🏆👌👌

    • @pivotalstats
      @pivotalstats  2 місяці тому

      You're very welcome! Thanks for watching!!

  • @monubhaiya9022
    @monubhaiya9022 6 місяців тому

    Thanks for helping us with this project ❤❤❤Please keep teaching ❤❤

    • @pivotalstats
      @pivotalstats  6 місяців тому

      Really glad it was helpful. Sure I will try to come up with more useful content 👍

  • @mahithamylo66
    @mahithamylo66 5 місяців тому +1

    Great content do more videos to help in PBI Mock Interviews, Thanks and God Bless you!
    😇

  • @user-sk3gd9xx7x
    @user-sk3gd9xx7x Місяць тому

    very helpful...thank you..

  • @bernardolara8366
    @bernardolara8366 17 днів тому

    the most straightforward dax tutorial ever

    • @pivotalstats
      @pivotalstats  16 днів тому

      Glad you liked it. Thanks for watching!

  • @deepdiveintolife
    @deepdiveintolife 7 місяців тому

    Great explanation

  • @chaitu361
    @chaitu361 3 місяці тому

    fan of your work....boss...

  • @Sanj20101
    @Sanj20101 Місяць тому

    Really great video, it covered everything and was easy to understand.. Thanks for this😊

  • @user-ve5gj5vo8e
    @user-ve5gj5vo8e 7 місяців тому

    Thank You

  • @akupatichiranjeevi6159
    @akupatichiranjeevi6159 5 місяців тому

    Kudos to your effort🎉🎉even one second also i don't missed it.. For me it is helpful alot... Thanks for awesome content

    • @pivotalstats
      @pivotalstats  5 місяців тому

      Really glad that it helped. Thanks for watching!

  • @user-qc1ct8jb7u
    @user-qc1ct8jb7u 2 місяці тому

    Really good ...

  • @ajitsahoopcm
    @ajitsahoopcm Місяць тому

    Thank you.....helpfull

  • @perfectionist6624
    @perfectionist6624 7 місяців тому

    Thanks ❤❤❤

  • @poeziya5236
    @poeziya5236 3 місяці тому

    thank you

  • @osoriomatucurane9511
    @osoriomatucurane9511 5 місяців тому

    This is absolutely awesome, concise and crystal clear! Well done Sir.
    Do u have a tutorial convering row and filter contexts?

    • @pivotalstats
      @pivotalstats  5 місяців тому +1

      Thanks! I did cover filter context on an high level in my previous data model videos but I will create a dedicated video soon. Thanks for watching!

    • @osoriomatucurane9511
      @osoriomatucurane9511 5 місяців тому

      @@pivotalstats fantastic! Looking forward to see it.

  • @2076mayank
    @2076mayank 5 місяців тому

    Amazing
    Looking for a video on data flow
    And Ms Fabric

    • @pivotalstats
      @pivotalstats  5 місяців тому

      Thanks!
      Sure I'll plan for something in future, since dataflow requires a premium license.

  • @nariroeplal1553
    @nariroeplal1553 2 місяці тому

    Best and easiest explained. Please do upload more😅

  • @jani1914
    @jani1914 4 місяці тому

    Not fully watched but best impression 🎉

  • @user-go5ri7zo9p
    @user-go5ri7zo9p 3 місяці тому

    Hi! How did you merge the two tables of sem1 score and sem 2 score, when im trying, there are 48 rows instead of 12, im guessing the similar subjects rows are getting repeated in the merged table

    • @pivotalstats
      @pivotalstats  3 місяці тому

      Hi, I think you must have skipped a step. In the video we are merging 2 columns within the same table and then finally using that merged column to utilize RELATEDTABLE to get required information from 2nd table.

  • @lalitkaushik1812
    @lalitkaushik1812 2 місяці тому

    Great job. how to get the second largest value from a column?

    • @pivotalstats
      @pivotalstats  2 місяці тому

      Thanks!
      To get the 2nd largest, you can use a combination of Var, Max & Calculate function. Something like below:
      SecLarg =
      var larg = MAX(PizzaSales[Sales])
      RETURN
      CALCULATE(MAX(PizzaSales[Sales]),PizzaSales[Sales] < larg)

    • @lalitkaushik1812
      @lalitkaushik1812 2 місяці тому

      @@pivotalstats Thank you so much dear. This is a great help. Please start making videos in hindi as well for wider audience.

  • @Madly-Chilled
    @Madly-Chilled 2 місяці тому

    Hi! a newbie here in PowerBI.Is this much DAX is enough to get into industry?

    • @pivotalstats
      @pivotalstats  2 місяці тому +1

      Hi, yes this is a good starting point for you. Once you understand how to structure the dax using this video, you can then move on to creating more complex logics by combining what you learned.

  • @1andtheOnly
    @1andtheOnly Місяць тому

    Hey Sajit Simon...thanks for this top tutorial on Power BI DaX. I am not sure if I am right but at 45:51 onwards you feed the argument for Column 4 that: IF(PizzaSales[Sales] >=10..... Shouldn't it be either "IF(PizzaSales[Price_USD]>=10" OR "IF(PizzaSales[Sales]>=100" ?

    • @pivotalstats
      @pivotalstats  Місяць тому

      Hi, I don't know whether I understood your question or not, but the main intent of this was to just show how to use IF along with AND, &&, OR, ||. So consider this as a blueprint with which you can create your own personal logic.
      Let me know if you meant to ask something else!

    • @1andtheOnly
      @1andtheOnly Місяць тому

      @@pivotalstats So at 45:46 you start explaining to us about the mashup with IF with AND, OR, && logics. Here for the example you use IF(PizzaSales[Sales] >=10... so 10 is too low a number for [Sales] so I was wondering.... were you actually referring to the [Price_USD]? Shouldn't it be "IF(PizzaSales[Price_USD]>=10. Or if it was [Sales] that you were actually referring to then shouldn't it be "IF(PizzaSales[Sales]>=100"? Hope you got my question? 🙂

  • @jawa5692
    @jawa5692 3 місяці тому

    Sir, will powerbi certification helpful?how to prepare for PL 300 certification?

    • @pivotalstats
      @pivotalstats  3 місяці тому

      Yes, definitely!
      Check out below link for understanding the broad outline suggested by Microsoft. Then you can use free resources on UA-cam or go for any paid course on Udemy etc.. for your preparation.
      learn.microsoft.com/en-us/shows/exam-readiness-zone/preparing-for-pl-300-prepare-the-data

  • @Mohamed-yb2xy
    @Mohamed-yb2xy 2 місяці тому

    hi tank you for your video pleas i need your help in a project i have two fact tables and i want calculate a KPI using DAX this KPI is the result of the devision of two columns one from the first fact table and the other from the other fact table but the probleme is that those fact tables are not related and i cant related them, but they have some sheard dimension tables, pleas tell me how can i calculate this KPI ,i have done manu search in the internet but i did not find the answeer ?

    • @pivotalstats
      @pivotalstats  2 місяці тому +1

      I doubt if that's possible but I will keep looking and let you know if I find a solution.

    • @Mohamed-yb2xy
      @Mohamed-yb2xy 2 місяці тому

      @@pivotalstats thank you, some people use treatas function to create a vitual relationship between two tables but i am still reading about that, yes pleas don't esitate if you found a solution.

  • @kavyamohan9725
    @kavyamohan9725 4 місяці тому

    Sir please post complete powerbi course to became a powerbi developer sir

    • @pivotalstats
      @pivotalstats  4 місяці тому

      Hi, you can check out the power bi playlist. It covers all concept which you need to become a pbi developer :
      ua-cam.com/play/PLvkYWwzsiISGhkvknBg9eWneAizEumD0D.html&si=rVPTKZ0_7zS0TCfh

  • @asp4628
    @asp4628 4 місяці тому

    Sir,please Do more real world project advance level

  • @Lepu-bz1kd
    @Lepu-bz1kd 4 місяці тому

    Content is very good, but your articulation of words are just wow. Make a course for articulation as well JK 😂

  • @SunriseBusinessClub
    @SunriseBusinessClub 5 місяців тому

    absolutely useless

    • @pivotalstats
      @pivotalstats  5 місяців тому

      If you can elaborate then that would be really helpful. I will use that feedback to generate even better content in future. Thanks!

    • @osoriomatucurane9511
      @osoriomatucurane9511 5 місяців тому +1

      I guess he meant absolutely useful

  • @AmitKumar-ix3kq
    @AmitKumar-ix3kq Місяць тому

    Please Correct me if I am wrong, but shouldn't the Function at 7:05 be RevDiscounted = SUMX(PizzaSales, ((PizzaSales[Sales] * PizzaSales[Price_USD])*.85)). Since the store ran a 15% discount so the pirce should be 85% of its initial price. Sorry I have not gone through the entire video at this point, but this doubt came to mind as soon as I saw this.

    • @pivotalstats
      @pivotalstats  Місяць тому

      Hi, You are absolutely correct. I made a mistake there, it should have been .85 instead of .15. Thanks for highlighting, cheers!