Advanced DAX [Full Course]

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

[MrPrakashsomani]

Excellent explanation to the Advance DAX functions in easy way. I like the comparison of using %ge to grand total and using DAX.

[mwaltercpa]

Great video, explaining the learning curve of DAX is very appropriate for business users. I remember feeling very confident, then feeling lost for a while.. to master DAX, you really do need to be willing to push through.

[wildecorrea]

BY
10:07 Variable: VAR + RETURN
13:30 Working with variables


20:24
1 Dynamic Measure =
2 VAR LastSaleDate = LASTDATE('Internet Sales Filtered'[Order Date]);
3 VAR LastDayOfMonth = LASTDATE('Date'[Date]);
4 RETURN
5 IF(LastSaleDate <> LastDayOfMonth;
[Forecast YTD Sales]; [YTD Sales])


23:24 CALCULATE
24:53 ALL
29:06
1 % of Total =
2 DIVIDE ([Total Sales];
3 CALCULATE([Total Sales];
4 ALL('Geography'[Country])))

34:53 FILTER
37:04
1 Quantity Sold =
2 COUNTROWS('MLS Data')

40:19
1 MLS Data 2016 =
2 FILTER('MLS Data';
3 YEAR('MLS Data'[Sold Date]) = 2016)

43:26
Quantity Listed =
2 CALCULATE([Quantity Sold];
3 USERELATIONSHIP('Date'[Date]; 'MLS Date'[Listing Date]))

52:05
1 Total Homes on Market =
2 CONTROWS(
3 FILTER(
4 ALL('MLS Data');
5 'MLS Data'[Sold Date] >= MIN('Date'[Date]) &&
6 'MLS Data'[Listing Date] <= MAX('Date'[Date])))

[officesuperhero]

I think the topics you cover here are excellent but your title of this video and description do not lend itself to getting more views. I suggest that you include topics in title and description. You deserve more views. You are a very good teacher.

[qingqingbales]

I love all your videos. It's easy to understand for beginners like me. Thank you so much for posting!

[khuramwani]

Mitchell I feel like I must pay for all your stuff. Your videos are are just Awesome! Thanks for this cool stuff

[Sylphs]

Just want to let you know that this video help me a lot ! Great work !

[christianbejani]

very clear explanation, thanks a lot for sharing.

[gbthakkar]

Hi, Great video. Thank you.
But wish to point out that the "Total Home on the Market" (53 min), is still incorrect.
The meaning of the formula is that, the home listed and sold in the same year.
So if we look at 2012- total listed is 260, so the value for "Total home on the market" can not be more than 260.
Please clarify.

[lma]

Great tutorial video! Thank your for tips and tricks. Your video helped me to solve a puzzle in my learning process. Thank you again.

[danieldelgado-lwbr]

This channel is amazing, It really adds some difficulty on power BI. I was tired of beginners tutorials

[jogdeepak]

Excellent way of explaining, thanks for the video.

[SM-csnt]

Good video.

But I wouldn’t call this ‚advanced‘ DAX

These are fairly basic DAX calculations that you learn through the beginning.

Something I would really like to see more of is how to nest iterator functions to perform calculations on a groupBy level.

For example if I have a sales order table with sales id and customer number, how do I perform calculations by grouping by customer Nr and then having evaluations made by that grouping.

These start to get fairly complex from the beginning so I would love to have some structured introduction to those types of measures.

[nguyenhoangtam]

Great video with detail explanation and guidance. Thank you very much

[abhijitvetal]

Kudos to you man You have done great job I was trying to find correct total throughout the Internet I didn’t get anything now I know. Thank you man really appreciated !!this was the video I needed indeed

[rammasilang]

Thank you very much for this content. You've given exact answers to the questions that I cannot find anywhere else in the internet. I totally relate to the learning curve presented and hopefully I can make important progress to the report I am building.

[Reduce_Scan]

Thank You,
please
language MDX That used in PivotTable
Is it related to DAX
and Are there any educational materials for this language?

[matuwuhou]

Thanks for a nice video! Can someone intuitively explain the first argument of ALL()? Why did he chose 'Geography'[Country] for calculating total sales? What if he chose 'Geography'[State] or anything else?

[decentmendreams]

Hi Mitch, this is an awesome application for a person such as myself who works in the hospitality industry. How can I modify the LASTDATE to show as of yesterday? I am trying to dictate a measure that says if it is before today use ACTUAL otherwise use the FORECAST. Thank you so much!
Additional:

I was able to find a solution for it.

Thanks again.

[this.is.lapc]

The USERELATIONSHIP function would be really helpful a long time ago for me. Thanks a lot.