Explain Power BI Formulas | Dataford Interview Questions

Your question is Explain Power BI Formulas. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

How did you derive this specific result, and what Power BI formula was used to calculate it?

Asked in the Technical Phone Screen stage. The interviewer asked deep technical questions about Power BI mechanics and formulas.

Candidate Task

Explain how you would trace the reported result from the visual to its underlying fields, filters, relationships, and measure logic.
State the DAX formula used, or explain what information is required before identifying the exact formula.
Clarify how filter context, row context, aggregation, and relationships affect the result.
Describe how you would validate the result in Power BI.

Your question is Explain Power BI Formulas. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

How did you derive this specific result, and what Power BI formula was used to calculate it?

Asked in the Technical Phone Screen stage. The interviewer asked deep technical questions about Power BI mechanics and formulas.

Explain how you would trace the reported result from the visual to its underlying fields, filters, relationships, and measure logic.
State the DAX formula used, or explain what information is required before identifying the exact formula.
Clarify how filter context, row context, aggregation, and relationships affect the result.
Describe how you would validate the result in Power BI.