Practice Test GeeksPower BI 778 Practice Test
← All Power BI 778 Flashcard Decks

DAX Formulas and Calculations Flashcards

6 cards from real Power BI 778 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 DAX Formulas and Calculations flashcards as text

  1. What does the RELATED function do in DAX?

    Answer: Returns a value from a related table along the many-to-one side

    RELATED retrieves a value from a column in a related table, traversing the relationship from the many side to the one side.

  2. What is the purpose of the DIVIDE function in DAX?

    Answer: Divides two numbers safely, returning an alternate result if denominator is zero

    DIVIDE safely handles division by zero by returning an optional alternate result instead of throwing an error.

  3. Which DAX function returns the number of distinct values in a column?

    Answer: DISTINCTCOUNT

    DISTINCTCOUNT counts the number of unique, non-blank values in a column.

  4. What does the EARLIER function do in DAX?

    Answer: References an outer row context in a nested row context iteration

    EARLIER accesses the value of a column in an outer row context when two nested row iterations are active.

  5. Which DAX function returns a table with duplicate rows removed?

    Answer: DISTINCT

    DISTINCT returns a one-column table containing all unique values from the specified column, excluding duplicates.

  6. What is evaluation context in DAX?

    Answer: The set of filters and row iteration state that determines how a DAX expression is evaluated

    Evaluation context in DAX refers to the combination of filter context and row context that controls how expressions are computed.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. learn.microsoft.com — Renewal, retake fee, passing score, exam format, test delivery, fees, time limit, exam information · verified Oct 2026