How to Use 7+Text Functions in DAX — DAX in Power BI — Chapter 15

We are going to explore CONCATENATE, CONCATENATEX, COMBINEVALUES, EXACT, FIND, SEARCH, LEFT, RIGHT and MID Text functions in DAX using practical examples. In any data analysis project, the text functions of DAX are playing very important roles. Using these functions…

How to Implement Normal Distribution in DAX - DAX in Power BI - Chapter 14

We are going to explore 4 Normal Distribution statistical functions in DAX using practical examples. Using DAX Statististical functions, we can very well determine the inferential statistics for different datasets in Power BI. In this blog, you are going to…

How to Use 27+ Statistical Functions in DAX - DAX in Power BI - Chapter 13

We are going to explore 28 key statistical functions in DAX using practical examples. According to Microsoft documentation, there are different statistical and aggregation functions in DAX. In this blog, you will explore functions related to the below items, average, maximum, minimum, count, median, standard…

How to Use Top 3+ Relationship Functions in DAX - DAX in Power BI - Chapter 12

We are going to look at 4 relationship functions in more detail with examples. I found, there are 4 relationship functions in DAX as per Microsoft documentation.  As the name suggested, these functions are for managing and utilizing relationships between…

How to Work with 17+ Date and Time Functions in DAX - DAX in Power BI - Chapter 11

We are going to look at 23 date and time functions in more detail with examples. As per Microsoft documentation, there are 23 date and time functions are available in DAX. These functions are more or less similar to excel…