TABLE FUNCTIONS

Question 1

Regardless of how many steps are necessary to travel from the original table to the related table, DAX follows the complete chain of relationships, and it returns the related column value. True/False

Answer 1

True

Question 2

In a one-to-many relationship, Related can access the _____side from the ______ side

Answer 2

one-side from the many-side

Question 3

RELATABLE returns a what?

Answer 3

A table containing all the rows related to the current row.

Question 4

If expression is on the one-side and you need to access the many side, use function ____________

Answer 4

RELATABLE

Question 5

SUMX(FILTER(‘Table’,’Table’[column] >1,),{Column 1]*[Column 2]))

Is this function best practice? Why or why not?

Answer 5

No it is not. You use calculate in this instance.

Question 6

Does DAX calculate the inside function first or outside function for nested functions?

Answer 6

Inside function

Question 7

The difference between scalar and table functions is that…..

Answer 7

that the former returns a single value, whereas the latter returns a table of one or more columns and one or more rows