DAX FunctionsWhich DAX function category includes functions that work row-by-row on a table?Scalar functionsIterator functionsTable functionsFilter functions

DAX FunctionsWhich function creates a summary table over a set of columns, returning combinations of unique values?CALCULATE()RELATEDTABLE()SUMMARIZECOLUMNS()DISTINCT()

Select the INCORRECT statement.A.The PU-functions are implemented when the data from a source table needs to be displayed alongside a target table. The source table must have an N:1 relationship with the target table.B.When implementing a PU-functions, the function will automatically assign the table which has N elements as the source table and the other as the target table.C.Unlike standard aggregators which change dynamically based on filters, PU-functions ignore global filters states and are only calculated once.

Which of the following DAX function is not available in Power BI Desktop?*UpperTrimVlookupIf command

Which of the following tables represents a function?Table 1   Table 2   Table 3x (input) y (output)2 23 24 2   x (input) y (output)14 214 314 4   x (input) y (output)0 0-3 -3-16 -16 Group of answer choicesNone of the Tables represent functions.Table 1 and Table 2 both represent functions but Table 3 does not represent a function.Only Table 2 represents a function.Only Table 3 represents a function.Table 1 and Table 3 both represent functions but Table 2 does not represent a function.

New measure (DAX Function) is generally used to create an aggregate level calculation.*TrueFalse