1

DAX for Power BI Professionals: From Basic Formulas to Complex Analytics

1 / 20

1) What is the main purpose of DAX in Power BI?

2 / 20

2) Which DAX function is used to create a table by summarizing data from another table?

3 / 20

3) What is the primary difference between calculated columns and calculated measures?

4 / 20

4) Which function is used to count distinct values in a column?

5 / 20

5) What is the purpose of the CALCULATE() function in DAX?

6 / 20

6) Which DAX function calculates the sum of an expression evaluated over a table?

7 / 20

7) What does the DAX function RELATED() do?

8 / 20

8) Which DAX function would you use to create a running total?

9 / 20

9) Which function allows you to shift time periods forward or backward in DAX?

10 / 20

10) What is the main use of variables in DAX?

11 / 20

11) Which DAX function returns the last non-blank value in a column?

12 / 20

12) What is context transition in DAX?

13 / 20

13) Which function would you use to handle multiple conditions in DAX?

14 / 20

14) Which DAX function is used to concatenate values with a delimiter?

15 / 20

15) What are the two types of evaluation contexts in DAX?

16 / 20

16) Which DAX function is used to calculate the year-to-date total?

17 / 20

17) What is the purpose of the LOOKUPVALUE() function in DAX?

18 / 20

18) Which function is used to return a table with all the rows that meet a specified condition?

19 / 20

19) Which DAX function is used to create virtual tables within measures or calculated columns?

20 / 20

20) What does the function SELECTEDVALUE() return in DAX?

Your score is

The average score is 75%

0%

Exit