Advanced DAX [Heavy Webinar]

The DAX language was designed specifically so that users could quickly learn the basics and immediately improve the analytical capabilities of their data models. But then what? The DAX language can be difficult to understand once you master the basics and begin moving on to more complex calculations.

In this heavy webinar, we will focus on the building blocks necessary for building more complex calculations in DAX.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

[CoopmanGreg]

I liked the way you encouraged students to be persistent with trying to understand the techniques and theory, saying that it is hard and even yourself had some struggles gaining the knowledge. Too many times, instructors act like everything is so simple, when it is not. Thanks for your honesty. I think it shows you care about your students learning. Thanks!

[robofski]

Great explanation of how Filter works, finally got it and it gave me an idea to solve a problem I'd been having with a custom calendar and previous year data where using the built in Time Intelligence function just didn't quite work! Thanks!

[sarojiniewijesiriwardana]

Thanks Mitchell. Can you pls tell us how to create a separate table for calculations?

[ahmedal-dossary]

You have shared an effective trick to workaround such problem.

Is there a way to force DAX to return YTD in case we have month / months with no sales? I can’t imagine creating a fictitious records with 0 sales for each month with no sales.

[mynameisyuriorlov]

examples are great. I learnt many things

[affiliatenetwork]

I'm not quire sure why we are seeing any information for the year of 2011 if we are using the sold date as the first filter in the houses available on the market measure. Looking at the data, there weren't any houses sold in 2011, only listed houses but our condition is Sold date greater or equal to min date. Yes, our min date probably contains values from 2011, but if our starting point is the first sold date in 2012 and the end point is the last listing date, why do we still have data shown for 2011?

[JoshuaDHarvey]

52:15 Hey Mitchell, first of all, thank you for another incredible webinar. I'm a couple years behind watching this but love all the webinar's you guys publish. For the last 2 days I've been really digging around trying to find a good explanation about the MAX() or MIN() on the other side of a Boolean operator and why that still respects the page level filtering context. I've seen similar formulas such as 30 day running total but I've only assumed that I just need to memorize that anything on the other side of the Boolean operator or inside a MIN(), MAX() will the page level filtering still apply. Is that not correct or how should I think about how the engine in handling and respecting external (implicit) filtering in accordance with MAX() AND MIN().

[premjitchowdhury]

I don't think sales were any where near in 2008 due to recession

[soumenin]

Dude Mitchell. Seems, like you want to spread fear among Audiences while describing "S" curve to your DAX teaching. Spread Love, Not fear..