Dax Introduction
The formula expression language DAX (Data Analysis Expressions) is applicable to a variety of BI and visualisation tools. Because the entire code is contained within a function, DAX is also known as a function language. There are two data types in DAX programming formulas: numeric and other. While Other includes string and binary object, Numeric includes integers, money, and decimals.
What is DAX?
The acronym DAX stands for Data Analysis Expressions. Microsoft created this language to interact with data in a number of their platforms, including Power BI, PowerPivot, and SSAS Tabular Models. It is intended to be straightforward and simple to learn while demonstrating the strength and adaptability of tabular models. You might liken it to Excel formulas taken to the next level.
Using DAX will truly unleash the capabilities of Power BI.
I have reached a point where I use a lot of the code in my daily work even though I am still far from a DAX expert and have coworkers who are beginning to ask more and more questions about it. I decided to write this article about why you should (or shouldn’t) use this tool from the data science/data analysis toolbox as a result.
DAX Functions
You can use several Function types in Power BI to analyse data and add new columns and metrics. It consists of operations from several categories, including
- Aggregate
- Text
- Date
- Logical
- Counting
- Information
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
Add Your Heading Text Here
The post Beginner’s Guide to Dax Functions in Power BI DAX appeared first on Data Science institute and Data Analytics Training institute.
This post first appeared on Coaching Tally Accounts & Finance ,taxation,bankin, please read the originial post: here
