Q&A

During the interview process for the position of data analyst or Power BI Engineer, as many companies often refer to it, the topic of DAX is often touched upon in practical scenarios and problem-solving. However, you may encounter some technical questions that tend to be somewhat complex, so you should be prepared for that moment.

Below, I present some of the questions that may arise during the interview, some of which I have personally asked while interviewing candidates, while others have been asked to me in some interview processes.

Question 1: What is the advantage of the DIVIDE function compared to the regular expression Expression A / Expression B?

Answer: Using the DIVIDE function has several advantages. One of them is preventing the display of invalid values in the report. Additionally, it avoids division by zero in cases where the denominator is an expression that could return zero.

Question 2: What is the difference between a measure and a calculated column...