Data Analysis Expressions (DAX)

…DAX, DAX is the language that we use when we just created these calculated columns,…such as heres unit price minus discount or the calculated feel.…If I click in this cell and…I go insert function, I can come through and pick whatever function I want.…Look at logical.…There's our standard logicals.…And come down to all.…And if I drill down, going to double click Calculate.…

Now Intelisense pops up and tries to help me.…I have Calculate here, and then I'm going to insert an expression.…Actually, I'm not going to, that's the next thing you would do,…which is why this is bolded.…And then, comma Filter1, comma Filter2, and then the ellipses, on and on.…I point out Calculate, even though this is just an introduction to just a touch on…DAX because Calculate is perhaps the most…powerful expression or function there is in all of DAX.…It's something, when you get more into DAX,…you absolutely want to take a look at.…

Calculate is similar to the I, if function over in Excel.…What it gives you the ability to do, is to add expressions that we just did,…