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

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

VALUES() vs DISTINCT()How do VALUES() and DISTINCT() functions differ in DAX?DISTINCT() returns a table, while VALUES() returns a listThey have no differenceVALUES() can return an additional blank row when there are null valuesDISTINCT() can be used in a row context, but VALUES() cannot

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

Suppose you are working on different inbuilt functions for performing data modeling on your application data. You have table say "mytable" which has a specific column called "Year". This field represents the calendar year. Now, you want to create a new calculated table with name "mytable2" having exact same number of columns as of "mytable" and get only those rows having the "Year" value as "2022". Pick the appropriate code snippet. mytable2 = NEW FILTER( 'mytable'[Year]=2022, mytable ) mytable2 = NEW FILTER( mytable, 'mytable'[Year]=2022 ) mytable2 = FILTER( mytable, 'mytable'[Year]=2022 ) mytable2 = FILTER( 'mytable'[Year]=2022, mytable )

How would you calculate the running total of sales amounts over time using DAX in Power BI? Use the CALCULATE function to calculate the running total Apply a filter to calculate the running total Define a relationship between tables to calculate the running total Use the SUM function to calculate the running total