DAX in Power BI stands for Data Analysis Expressions. It is a formula expression language that can be used in various BI and data visualization tools. It is also known as a function language in which the entire code is inside the function. It consists of two data types – Numeric, string, and binary objects. The numeric data type in DAX contains integers, decimals, and currency.
Power BI uses various DAX functions in order to analyze the data and create new measures and columns. These functions include:
- Text: Text functions include REPLACE, UPPER, SEARCH, CONCATENATE, and FIXED
- Aggregate: It includes functions like MIN, MAX, SUM, Average, and SUMX
- Logical: Logical DAX functions include AND, OR, IF, NOT, and IFERROR
- Information: It consists of functions such as ISTEXT, ISNUMBER, ISNONTEXT, ISBLANK, and ISERROR
- Counting: It includes DAX functions like COUNT, COUNTROWS, COUNTA, COUNTBLANK, and DISTINCTCOUNT
- Date: The Date function in DAX includes HOUR, WEEKDAY, DATE, NOW, and EOMONTH
If you want to learn more about Power BI then read Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.
Learn Power BI Course from this video :
Back