3 Calculated Tables Flashcards
What are calculated tables in Power BI?
Derived tables from existing ones with selected columns and calculated columns.
Provide an example of a calculated table.
Creating a ‘Calculated Food Sales’ table from a ‘food sales’ table.
List the selected columns for the calculated table example.
- Category
- Date
- Quantity
- Unit Price
- Total Price
Name the calculated columns in the calculated table.
- Discounted Price
- Total Cost
- Profit
What DAX functions are used to create calculated tables?
ADDCOLUMNSSELECTCOLUMNS
Fill in the blank: The formula for Discounted Price is _______.
Total Price * 0.9
What is the formula for Total Cost?
Quantity * Unit Price
Why are calculated tables useful?
- Data Organization
- Performance
- Data Modeling
Explain the purpose of the ADDCOLUMNS function.
Adds new calculated columns to an existing table or table expression.
What does the SELECTCOLUMNS function do?
Creates a new table by selecting specific columns from an existing table.
What should be considered for DAX optimization?
- Size of data
- Complexity of calculations
True or False: Calculated tables are re-calculated when the data model is refreshed.
True
What is a recommended practice for error handling in calculated columns?
Incorporate error handling functions like IFERROR.
How can calculated tables be used in relation to measures?
They can provide more flexible and powerful analysis.
What features does the DAX editor in Power BI Desktop provide?
- IntelliSense
- Syntax highlighting
