Using DAX operators


show more Using DAX operators provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Using DAX operators

Like Excel, the DAX language uses operators to summarize and compare values. You'll probably recognize the Arithmetic operators from your regular Excel formulas, but some of the other operators might require some explanation. In this movie, I'll start out with an overview of the operators you can use and then show you some examples of expressions with a few of them. DAX operators are divided into several different groups. The first is the Arithmetic and it's almost certainly familiar to you. You have the plus sign for addition, minus for subtraction, or to indicate a negative number, the asterisk for multiplication, and the forward slash for division.

Then there are the Comparison operators, and you probably would have used these if you created a filter or a conditional format inside of Excel. Equal tests for Equal To, then there is Not Equal To, Greater Than, and so on. Then the last two groups are the Text and Logical groups. So for Text you have the ampersand which you ...

Using DAX operators
Video duration: 4m 44s 3h 43m Intermediate

Viewers:

Using DAX operators provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...