All language subtitles for 11. Common DAX Function Categories

All right.

Last note before we shift into daks demo mode I want to lay out the common function categories and most

of these should look familiar to excel users.

These map pretty closely with Excel function categories especially math and stats.

Logicals text and date and time functions.

One area that is quite a bit different in daks is the filter function section which will dive into later

in the section.

But basically what we've got here the math and stats category your basic aggregation functions are some

Max men average count etc. plus some interesting daks formulas called iterators which actually evaluate

row by row.

Sometimes those are called X functions because they all ended at x some x average x rank X Max sex etc.

and for Excel users those were just like a some product.

More on that to come.

Next up we've got logicals basically returning information about values in a given conditional expression.

So these are all based around those if statements if and or not there's a new one called switch which

is interesting.

And you've got very familiar text functions.

These manipulate text strings can also be used to control formats for things like dates times or numbers

and they should look very familiar as well concatenate or ampersand left men right.

You've got capitalization rules like the ones we practice in the query editor with upper or lower prop..

And then some useful options like substitute and trim as well.

Now filter functions this is where things feel a little bit foreign and unfamiliar.

These include Look up style functions based on related tables and table relationships in your model

and filtering functions to create more dynamic types of calculations.

So the most common example of all is a formula called calculate which will spend some time focusing

on the other ones that will really hit here or filter all and related but tons of other options here

as well.

And then in the date and time category you've got your basic date and time functions as well as some

advanced time intelligence operations.

So your basic ones should look pretty familiar date diff your frac your component functions like.

Year month day or hour minute second got volatile functions like today and now and then time intelligence.

This is really interesting.

We'll do some cool downloads there like dates year to date dates quarter date date add and dates in

period.

These let you do some really interesting things like calculate rolling averages year to date totals

and other date specific comparisons.

So big caveat here this that you're looking at here is not a comprehensive list.

There are many other daks functions some of which are more advanced some of which are more specialized.

There's trigonometry functions parent child functions info functions.

So the ones that we're going to cover here are some of the most common and some of the most powerful

but this will not be a fully comprehensive review of daks.

The plan here is to get you started with the basics and hopefully give you a deep enough understanding

that you can begin to explore some more complicated more advanced scenarios on your own so that buckle

up it's time to start running Sendak's.