15 DAX functions you must know in Power-BI
WHAT IS DAX?
DAX stands for Data Analysis Expressions, i.e. such expressions or formulas that are used for data analysis and calculations.
DAX formulas are very useful in Power BI, as they help data analysts to use the data sets they have to the fullest potential.
With the help of the DAX language, you can use advanced calculations in your Power BI reports and make it with more depth and detail.
So Now we’ll be looking at some commonly used functions that you should know.
1. AVERAGE :
Returns the average (arithmetic mean) of all the numbers in a column.
2.AVERAGEA :
Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.
3.AVERAGEX :
Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
4.SUM
SUM is a simple aggregation function. It summarizes a value based on a filter context.
5.SUMX
SUMX is the sum of an expression, the X at the end of this function is for expression. This function gives you the sum of any expression.
6. COUNT DAX Function:
The COUNT function counts the number of cells in a column that contain non-blank values.
7. COUNTA DAX Function:
The COUNTA function counts the number of cells in a column that are not empty.
8.COUNTX DAX Function:
The COUNTX function counts non-blank results when evaluating the result of an expression over a table.
9. ISNUMBER
Checks whether a value is a number, and returns TRUE or FALSE.
10. CROSSJOIN
Returns a table that is a cross join of the specified tables.
11. MIN
Returns the smallest value in a column.
12. MAX
Returns the largest value in a column.
13. MEDIAN
Median is nothing but the middle value, so here we can say that the Median function will return the 50th percentile of values in a column.
14.CONCATENATE
Concatenate, means linking (things) together while in DAX function Concatenate Joins two text strings into one text string.
15.CALENDAR
Returns a table with one column of all dates between Start Date and End Date.
There are 250+ functions stored in the DAX library, and it is not humanly advisable to learn all of them, but if you can remember all of them — everything, then—
Congrats, You are a Genius!
The above 15 DAX Functions are something that I have used and encountered the most during my time with Power-BI. Feel free to ADD or SUBTRACT according to your own comfort and need.
That’s it for this Article , I hope you liked it. I would really appreciate if you would share this Article and Drop your Thoughts, Suggestions and Recommendations, always looking to Improve, Learn and Grow.
Until Next Time,
