Week 5 - DAX

DAX stands for ___

• Data Analytics Expressions

• Data Analysis Execution

• Data Analytics Examples

• Data Analysis Expressions

Which two types of fields can DAX be used to create?

• Calculated Column & Calculated Fields

• Calculated Column & Measures

• Calculated Fields & Measures

• Measures & Calculated Items

Which of the following formulas would make the most sense as a calculated column?

• =SUM(Sales[quantity])

• =AVERAGE(Products[RetailsPrice])

• =DISTINCOUNT(Customer[CustomerName])

• =Products[RetailsPrices]*0.75

What always surrounds a column name in a DAX formula?

• &&

• Parentheses ( )

• Brackets [ ]

• Exclamation!

Can a formula contain more than one function?

• Yes

• No