DAX Filter Context Basics [Full Course]

Sdílet
Vložit
  • čas přidán 28. 08. 2024
  • After you finish this course:
    📄 prag.works/con...
    Student files
    ✔️prag.works/con...
    During this session, Mitchell will provide an in-depth overview of the concept of filter context in the context of DAX (Data Analysis Expressions). The discussion will delve into the ways in which filter context impacts the authoring of DAX measures, including how it can affect the behavior and results of measures. Furthermore, Mitchell will explain how advanced measures can be created by overriding or modifying the default filter context in order to achieve more sophisticated and precise calculations. This session promises to provide valuable insights and techniques for mastering the nuances of filter context in DAX, empowering attendees to create powerful and flexible measures in their analysis of data.
    Next event:
    Intergalactic Learn With The Nerds Day
    ✔️prag.works/int...
    Next step on your journey:
    👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/lwt...
    🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
    🔗Pragmatic Works Boot Camps: pragmaticworks...
    🔗Pragmatic Works Hackathons: pragmaticworks....
    🔗Pragmatic Works Virtual Mentoring: pragmaticworks....
    🔗Pragmatic Works Enterprise Private Training: pragmaticworks....
    🔗Pragmatic Works Blog: blog.pragmaticw...

    Let's connect:
    ✔️Twitter: / pragmaticworks
    ✔️Facebook: / pragmaticworks
    ✔️Instagram: / pragmatic.w. .
    ✔️LinkedIn: / prag. .
    Pragmatic Works
    7175 Hwy 17, Suite 2 Fleming Island, FL 32003
    Phone: (904) 638-5743
    Email: training@pragmaticworks.com
    #PowerBI #DAX #PragmaticWorks #DevinKnight #Training #Microsoft#Tech #FreeConference #LearnWithTheNerds
    **Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only.

Komentáře • 20

  • @PragmaticWorks
    @PragmaticWorks  Před 6 měsíci +2

    👉 Important files:
    ◉ Download Your Student Files - prag.works/context-with-dax-student-files-download
    ◉ Download Your Certificate of Completion - prag.works/context-with-dax-certificate
    ◉ Download DAX Guidebook - share.hsforms.com/1khBLVNX1RnuyJJROpSAqaA8xue

  • @osPA78
    @osPA78 Před 6 měsíci +3

    Your breakdown of the difference between SAMEPERIODLASTYEAR and PREVIOUSYEAR is the stuff of LEGENDS!!!! There is no emoticon to express my gratitude for that but I will just say...THANK YOU!!!!!

  • @chiraggarg4742
    @chiraggarg4742 Před 4 měsíci +2

    Hey everyone, greetings from the digital cosmos! It's fascinating to see such a diverse array of locations represented here. Whether you're waving hello from the tranquil Lake of the Ozarks or bustling Munich, soaking in the sunny vibes of Florida or the cultural richness of Ethiopia, every greeting adds a unique color to our digital tapestry. Let's make this session an engaging journey together, learning and growing from each other's perspectives.

  • @doriginal69
    @doriginal69 Před 5 měsíci +1

    That Same period last year thing happened to me and now I finally understand it. Thanks.

  • @jayxpea
    @jayxpea Před 10 měsíci +1

    this explains so many issues ive experienced. Absolutely ripper of a video. Thanks so much

  • @worldimpress
    @worldimpress Před rokem

    I didnt manage to join yesterday and I regret it. because I really love to watch your hands-on courses, and you are a really great teacher because I can hear that you love it! Great explanations with power (bi :D), I mean energy. Thank you! I stay tuned for the outcoming :)

  • @betsegawlemmaamersho1638

    Thanks Michell and Pragmatic Works Team

  • @optimistprime709
    @optimistprime709 Před 3 měsíci

    Very informative. Thank you so much.

  • @henryalferink1941
    @henryalferink1941 Před 3 měsíci +1

    Very helpful!

  • @khajvand
    @khajvand Před 4 měsíci +1

    Thanks for sharing

  • @tikummacmillianngu6477

    Hello sir, Thanks very much for your strategic aspects in DAX. I really enjoy it. Please, can you do a session on how to get the values of the previous week of the same year? Thanks sir.

  • @PMGRlajhi
    @PMGRlajhi Před rokem +1

    Thank you, it was great, as always. Maybe a bit more nerdish than usually 😁

  • @osoriomatucurane9511
    @osoriomatucurane9511 Před 7 měsíci

    Absolutely sensational tutorial on filter evaluation context. I am at earlier stage of my power bi journey and I am glad to have found the stuning tutorials on the daunting DAX and evaluation context by Michell Petersen. Now, on creating Total US Sales measure, mint 24:17, using calculate(), Mr Business Enginner, " is suggesting using the Sum×() instead, in creating table" . Where does this fit in? Could you kindly write the equivalent expression showing how it works and produce the same results?

  • @Anonymous-1011
    @Anonymous-1011 Před rokem

    Thank you sir.

  • @timarrington2245
    @timarrington2245 Před rokem +1

    Great class on Filter context.
    Is there a way to get a completion certificate, some kind of acknowledgement of attendance?

    • @PragmaticWorks
      @PragmaticWorks  Před rokem

      Hey Tim, you can get a certificate of completion here:
      prag.works/context-with-dax-certificate
      Thanks!

  • @Milabdi
    @Milabdi Před 5 měsíci

    Why do we need to use Dax instead, we can do some steps in the power query steps very easily?! I can't understand the utility of Dax. Could you please explain it to me

  • @varunbhatia577
    @varunbhatia577 Před rokem

    Thanks for this session as it was really helpful… just to get along can you pls share the download link for the files.

  • @thefamousdjx
    @thefamousdjx Před 5 měsíci

    Seems to me the total row issue with YTD is a bug in powerbi. I think it’s reasonable that this is confusing because it is poor implementation

  • @myexcelacademy69
    @myexcelacademy69 Před rokem

    Would like to see a video on Expanded tables please