PL-300 · Question #474
You have a Power BI model that contains a table named Expenses. The table contains the following columns: - Date - Amount - Category - Expense ID - Employee ID Expenses are recorded by employees…
The correct answer is A. Sum('Expenses'[Amount]). Note: Data Analysis Expressions (DAX), SUM Adds all the numbers in a column. The following example adds all the numbers that are contained in the column, Amt, from the = SUM(Sales[Amt]) https://learn.microsoft.com/en-us/dax/sum-function-dax
Question
You have a Power BI model that contains a table named Expenses. The table contains the following columns:
- Date
- Amount
- Category
- Expense ID
- Employee ID
Expenses are recorded by employees, and each expense has a unique expense ID. You need to create a DAX measure that will calculate the total amount of expenses. Which DAX expression should you use?
Options
- ASum('Expenses'[Amount])
- BMax('Expenses'[Amount])
- CSum('Expenses'[Expense ID])
- DCount('Expenses'[Amount])
How the community answered
(23 responses)- A78% (18)
- B4% (1)
- C4% (1)
- D13% (3)
Explanation
Note: Data Analysis Expressions (DAX), SUM Adds all the numbers in a column. The following example adds all the numbers that are contained in the column, Amt, from the = SUM(Sales[Amt]) https://learn.microsoft.com/en-us/dax/sum-function-dax
Community Discussion
No community discussion yet for this question.