techmax technologies Power BI Developer Interview Questions and Answers

Sequence No Questions

Power Bi Fundementals

We had a bunch of questions with the manager and I was selected to round two which was more technical.

Q1. I had a technical round on SQL. and Power BI Measure.
Add your answer
Q2. Find the 3rd highest salary for a group of people.
Add your answer
Q3. What is coalesce function
Ans. 
Coalesce function returns the first non-null value from a list of values.
• Coalesce function is used in SQL and other programming languages.

• It takes two or more arguments and returns the first non-null value.

• If all arguments are null, it returns null.

• Example: COALESCE(NULL, 'hello', NULL, 'world') returns 'hello'.
Answered by AI
Add your answer
Q4. Difference between slicer and filter pane in powerbi desktop
Ans. 
Slicer and filter pane are both used to filter data in Power BI, but slicers are visual while filter pane is a list.
• Slicers are visual elements that allow users to filter data by selecting options from a dropdown list or a range slider.

• Filter pane is a list of filters that can be applied to a report or a visual, and it allows users to filter data by selecting options from a list or typing in a search box.

• Slicers are mo...read more
Answered by AI
Add your answer
Q5. Difference between iterators and aggregator function in dax
Ans. 
Iterators are used to iterate over a table or column, while aggregator functions perform calculations on a set of values.
• Iterators include functions like FILTER, SUMX, and AVERAGEX.

• Aggregator functions include functions like SUM, AVERAGE, and COUNT.

• Iterators are used to perform calculations on a row-by-row basis, while aggregator functions perform calculations on a set of values.

• Iterators can be used to filter data bef...read more
Answered by AI
Add your answer