DAX Functions

A DAX function is a previously written formula that performs calculations using input values. A column reference, numbers, text, constants, references to other formulas or functions, and logical values like TRUE or FALSE are all acceptable function arguments. They must be supplied to the function in a particular sequence. Every function performs a particular operation on the values in an argument. Multiple arguments can be supported by a DAX formula.

Types of DAX Functions

• Date and Time Functions
• Time Intelligence Functions
• Information Functions
• Logical Functions
• Mathematical and Trigonometric Functions
• Statistical Functions
• Text Functions
• Parent-Child functions
• Other functions
• Table functions

The different DAX function types are described above. A DAX function is a previously created formula that computes using values passed to it as arguments. We now look at DAX Logical Functions:

Data analysis expressions, or DAX, are formulas or expressions used in calculations and data analysis. These expressions contain a variety of different functions, operators, and constants that are all evaluated collectively as a single formula to yield the desired outcomes (value or values). DAX formulas are very beneficial in BI tools like Power BI because they help data analysts get the most out of the data sets they already have.