Preview Mode

large

Create Relationships Between Tables

Introduction to DAX (Data Analysis Expressions)

Add a Calculated Column

Create a Measure

Exercise 03

Why do we create relationships between tables?

To reduce file size

To speed up refresh

To format visuals

To connect related data across tables

What is the main difference between a calculated column and a measure?

Calculated columns cannot use DAX

Calculated columns only work in visuals

Measures are created in Power Query

Measures are calculations that can be applied report wide and do not appear as columns

Which DAX formula would you typically use to total sales?

SUM(Sales[Amount])

COUNT(Sales[Amount])

AVERAGE(Sales[Amount])

CONCATENATE(Sales[Amount])

Up next - Visualizations & Reports