What does the SUM function do in Power BI?
The SUM function adds up all the numbers in a column or expression and returns the total.
How does the AVERAGE function work in Power BI?
The AVERAGE function calculates the mean value by adding all numbers in a column and dividing by the count of those numbers.
Write a simple DAX formula to calculate the total sales using the SUM function.
Total Sales = SUM(Sales[Amount])<br>This adds all values in the Amount column of the Sales table.
Write a DAX formula to find the average sales amount.
Average Sales = AVERAGE(Sales[Amount])<br>This calculates the average of the Amount column in the Sales table.
Can SUM and AVERAGE functions be used on text columns?
No, both SUM and AVERAGE only work on numeric columns. Text columns will cause errors.
What will SUM(Sales[Amount]) return?
The SUM function adds all values in the column, so it returns the total sales amount.
Which function calculates the mean value of a numeric column?
AVERAGE calculates the mean by dividing the sum by the count of values.
What happens if you use SUM on a text column?
SUM only works on numbers. Using it on text causes an error.
Which DAX formula calculates the average sales amount?
AVERAGE(Sales[Amount]) returns the mean sales amount.
What is the result of SUM(Sales[Amount]) if the column has values 10, 20, and 30?
Adding 10 + 20 + 30 equals 60, so the sum is 60.
Explain in your own words how the SUM function works in Power BI.
Describe a situation where you would use the AVERAGE function in a sales report.