Power BI DAX SUM Function

The Power BI SUM function is a DAX aggregate function that adds all the numeric values in a given column to find the total or sum of those records. This article explains the DAX SUM function to perform the aggregation and return a single decimal number. In real-time, it is very helpful to calculate the … Read more

Power BI Charts

The following is the list of charts that are available to work. Format Power BI Charts tutorial The following Power BI tutorials section covers the formatting options for the data analytics charts.

Power BI DAX Functions

This article shows the Power BI Dax functions, and the following are the list of available ones.

Power BI DAX String Functions

Let me show you how to use Power BI DAX String Functions with examples. Microsoft Power BI DAX provides various String Functions such as LEN, LEFT, RIGHT, LOWER, UPPER, MID, SUBSTITUTE, FORMAT, CONCATENATE, CONCATENATEX, REPT, UNICHAR, VALUES, etc. To demonstrate these Power BI DAX String functions, we are going to use the below shown data. As … Read more

Power BI DAX Math Functions

How to use Power BI DAX Math Functions with examples?. Microsoft Power BI DAX provides various Math or mathematical Functions such as CEILING, FLOOR, CURRENCY, INT, SQRT, POWER, MOD, DIVIDE, ROUND, ROUNDUP, ROUNDDOWN, LCM, GCD, etc. To demonstrate the Power BI DAX Math functions, we are going to use the below shown data. As you … Read more

Power BI DAX Trigonometric Functions

How to use Power BI DAX Trigonometric Functions with examples?. Microsoft Power BI DAX provides various Trigonometric Functions such as EXP, COS, SIN, TAN, COSH, ACOS, ACOSH, ASIN, SINH, ASINH, ATAN, ATANH, LN, LOG, LOG10, etc. To demonstrate these Power BI DAX Trigonometric functions, we are going to use the below shown data. As you … Read more

Power BI DAX Date Functions

Let us see how to use Power BI DAX Date Functions with examples. Microsoft Power BI DAX provides various Date Functions such as Year, Month, Day, Calendar, date, time, datediff, now, today, utcnow, utctoday, datevalue, timevalue, etc. To demonstrate these Power BI DAX Date functions, we use the below-shown data. As you can see, there are … Read more

Power BI DAX Logical Functions

How to use Power BI DAX Logical Functions with examples?. Microsoft Power BI DAX provides various Logical Functions such as IF Statement, AND, OR, NOT, IN, TRUE, FALSE, IFERROR, SWITCH, etc. To demonstrate these Power BI DAX Logical functions, we use the below-shown data. As you can see, there are 15 records in this table. … Read more

Power BI DAX Aggregate Functions

How to use DAX Aggregate Functions in Power BI with examples?. Microsoft Power BI DAX provides various Aggregate Functions, which allows us to perform aggregations such as calculating sum, average, minimum, maximum, etc. To demonstrate these Power BI DAX aggregate functions, we are going to use the below-shown data. As you can see, there are … Read more

Power BI Q&A

In this article, we will introduce Power BI Q&A and provide an overview of its significance in data analysis, customizing questions, and advanced options. Power BI Q&A helps you ask business questions or analyze data using natural language. It means when you ask a question in a regular or everyday language, you can get visual … Read more