DAX - Tables

Question 1

How can you include columns from another table to iterate over?

Answer 1

You must use RELATED or RELATEDTABLE functions to bring the data into the table you want to iterate over

Question 2

SUMMARIZE syntax

Answer 2

SUMMARIZE(TableName, GroupByColumn1, GroupByColumn2, GroupByColumn…, Name1, Expression1, Name2, Expression2…)

Question 3

SUMMARIZE example

Answer 3

SUMMARIZE(
Sales, //Table
DateTime[CalendarYear], //Group By 1, ProductCategory[ProductCategoryName],
//Group By 2,
“Sales Amount”, //Name1
SUM(Sales[SalesAmount]), //Expression1
“Discount Amount (USD)”, //Name2
SUM(Sales[DiscountAmount]) //Expression2
)

Question 4

How does the SUMMARIZE function work?

Answer 4

It creates a summary table by grouping data based on one or more columns.

Question 5

How do you clone a table using DAX?

Answer 5

ClonedTableName=ALL(Original_Table_Name)

Example
Sales Data=ALL (Sales)

Writing a long sentence to left justify

Question 6

Why would you want to clone a table?

Answer 6

To perform manipulation or analysis on data while preserving the original records.

Question 7

What does the cloned table inherit?

Answer 7

The cloned table inherits the Original table’s:
- Columns
- Data
- Relationiships

Question 8

What is the difference between a cloned table and a calculated table?

Answer 8

Cloned Tables
Simple duplicates of the original table

Calculated tables created based on
- Calculations
- Transformations
- Aggregations

For example, you could create a calculated table showing each bicycle model’s total sales by year

Question 9

Best practices when creating calculated tables

Answer 9

• Optimize DAX calculations
  Complex calculations slow down model performance
• Use variables to enhance formula readability. Variables are recommended whenever you have a complex expression.