https://www.tutorialspoint.com/power_bi/dax_basics_in_power_bi.htmDAX Functions
In Power BI, you can use different function types to analyze data, and create new columns and measures. It includes functions from different categories such as −
- Aggregate
- Text
- Date
- Logical
- Counting
- Information
Power BI provides an easy way to see the list of all functions. When you start typing your function in the formula bar, you can see the list of all functions starting with that alphabet.
Aggregate Functions
DAX has a number of aggregate functions.
- MIN
- MAX
- Average
- SUM
- SUMX
Counting Functions
Other counting functions in DAX include −
- DISTINCTCOUNT
- COUNT
- COUNTA
- COUNTROWS
- COUNTBLANK
Logical Functions
Following are the collection of Logical functions −
- AND
- OR
- NOT
- IF
- IFERROR
TEXT Functions
- REPLACE
- SEARCH
- UPPER
- FIXED
- CONCATENATE
DATE Functions
- DATE
- HOUR
- WEEKDAY
- NOW
- EOMONTH
INFORMATION Functions
- ISBLANK
- ISNUMBER
- ISTEXT
- ISNONTEXT
- ISERROR
DAX Calculation Types
In Power BI, you can create two primary calculations using DAX −
- Calculated columns
- Calculated measures
No comments:
Post a Comment