DAX Filter Context Basics [Full Course]

[@PragmaticWorks]

👉 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]

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

[@adeayoadewale-vr5pp]

As someone just learning Power BI for the first time, your videos have been a Godsend and I feel like I'm growing faster than I would have imagined.

[@jayxpea]

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

[@doriginal69]

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

[@chiraggarg4742]

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.

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

[@sraoarjun]

You sure know that no one can explain DAX concepts better than you right ? Cheers🎉

[@betsegawlemmaamersho1638]

Thanks Michell and Pragmatic Works Team

[@optimistprime709]

Very informative. Thank you so much.

[@osoriomatucurane9511]

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?

[@AnkiSandinge]

I have a question on the part where you add the relative date filter (at the timestamp 1:11:08 in the video). It's Nov 22nd 2024 when I try this and I obviously can't get the same result as you get in the video. Is there a way I can get the same visual result as you're getting in the video OR do I just have to trust that it works? Well why did I had to ask before I tried the advanced filtering adding the dates that were the result of your relative filter in the video??? That did the trick. I choose to not delete the question as someone else might get the same problem as I had and he /she can get the workaround from the comments 😀

[@henryalferink1941]

Very helpful!

[@PMGRlajhi]

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

[@khajvand]

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.

[@Anonymous-1011]

Thank you sir.

[@excelanalysis]

Love from Bangladesh

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

[@Milabdi]

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

[@RohitSharma-uw2eh]

Can you create audio track for Indian

[@myexcelacademy69]

Would like to see a video on Expanded tables please

[@thefamousdjx]

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