DAX Filter Context Basics [Full Course]

Рет қаралды 33,642

Жыл бұрын

After you finish this course:
📄 prag.works/context-with-dax-c...
Student files
✔️prag.works/context-with-dax-s...
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/intergalactic-lear...
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/lwtn-trial
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

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.

Пікірлер: 20

@PragmaticWorks 4 ай бұрын

👉 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

@chiraggarg4742 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.

@osPA78 4 ай бұрын

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

@worldimpress Жыл бұрын

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 :)

@doriginal69 2 ай бұрын

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

@jayxpea 7 ай бұрын

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

@betsegawlemmaamersho1638 Жыл бұрын

Thanks Michell and Pragmatic Works Team

@optimistprime709 Ай бұрын

Very informative. Thank you so much.

@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 Жыл бұрын

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

@henryalferink1941 27 күн бұрын

Very helpful!

@khajvand Ай бұрын

Thanks for sharing

@Anonymous-1011 10 ай бұрын

Thank you sir.

@osoriomatucurane9511 4 ай бұрын

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?

@timarrington2245 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

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

@varunbhatia577 Жыл бұрын

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

@myexcelacademy69 Жыл бұрын

Would like to see a video on Expanded tables please

@Milabdi 2 ай бұрын

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