Semi-Additive Measures Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Create Model Calculations with DAX

Semi-Additive Measures Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    What is the primary characteristic of a semi-additive measure in DAX?

  2. 2

    Which DAX function is most commonly used to calculate the 'Ending Balance' for a semi-additive measure?

  3. 3

    You need to calculate the inventory level at the end of each month. If you use a standard SUM measure, what is the most likely error in your report?

  4. 4

    When using CALCULATE with LASTNONBLANK, why is it important to provide a measure as the second argument?

  5. 5

    Consider an 'Account Balance' table. You want to calculate the 'Opening Balance' for a selected period. Which pattern is the most effective approach?