PwC Power BI Developer Interview Questions and Answers for Freshers

Q1. Scenario based on filter table
Add your answer
Q2. Find rolling total without reset
Ans. 
Calculate rolling total without resetting at specified interval
• Use DAX formula with functions like CALCULATE, FILTER, and EARLIER

• Create a measure that calculates the running total based on the current and previous rows

• Consider using variables to store intermediate results for efficiency
Answered by AI
Add your answer
Q3. Shift one cell Down in table using dax
Ans. 
Use DAX function to shift one cell down in a table
• Use the LAG function in DAX to shift values down in a column

• Specify the number of rows to shift as a parameter in the LAG function

• Example: LAG([Column], 1) will shift values in 'Column' down by one row
Answered by AI
Add your answer

Q1. What is calculated col and measure
Ans. 
Calculated columns are columns created in Power BI by using DAX formulas, while measures are calculations based on the data model.
• Calculated columns are static and stored in the data model, while measures are dynamic and calculated on the fly.

• Calculated columns are used for adding new data to a table, while measures are used for aggregating data or performing calculations.

• Examples of calculated columns include adding a...read more
Answered by AI
Add your answer
Q2. What is numerical range parameter
Ans. 
Numerical range parameter is a parameter that defines a range of numerical values for a specific variable or function.
• It is used to specify a range of numerical values that a parameter can take.

• It helps in filtering data based on a specific numerical range.

• For example, a numerical range parameter can be used to filter sales data for products with prices between $50 and $100.
Answered by AI
Add your answer
Q3. What is field parameter
Ans. 
A field parameter is a variable that is used to pass values to a function or method.
• Field parameters are used to customize the behavior of functions or methods.

• They can be used to filter, sort, or group data in Power BI reports.

• Examples include filtering data based on a specific date range or sorting data by revenue.
Answered by AI
Add your answer

Q1. Introduction questions
Add your answer
Q2. Technical questions
Add your answer

Q1. Introduction questions
Add your answer
Q2. Salary description
Add your answer

Q1. All filter in Power BI
Ans. 
Filters in Power BI allow users to slice and dice data to focus on specific information.
• Filters can be applied at report, page, or visual level

• Types of filters include slicers, cross-filtering, and drill-through filters

• Filters can be based on specific values, ranges, or conditions
Answered by AI
Add your answer

Q1. DAX ? WHAT ARE TIME INTELLIGENCE FNCS
Ans. 
Time intelligence functions in DAX are used to perform calculations based on dates and times.
• Time intelligence functions help in comparing data over different time periods.

• Functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN are commonly used for time intelligence.

• They can be used to calculate year-to-date totals, compare values with previous periods, and more.
Answered by AI
Add your answer
Q2. FOCUS ON SQL AND DAX
Add your answer

1. One question was given to be solved in 1 hour. Question was medium level based on strings.

Q1. 1. 1:1 interview, mostly discussion around OOPS concepts and some basic dynamic programming questions.
Add your answer

1. 3 questions were given out of which any 2 needed to be solved. 1 question related to Database design and query, 2 questions related to DSA, both DSA questions were medium-hard type based on Dynamic programming and graph.
I solved one Dynamic programming question and Database question.

Q1. 1. This round was the follow up of last case study round. Interviewer gave various use cases to test on the algorithms that I had written. Some discussion related to OOPS concepts and Database design quest...read more
Add your answer

Q1. It was final discussion, mostly around cultural fit and classic HR questions. It was easy one, I'd say.
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

This test consists of two coding questions and some MCQ regarding computer fundamentals.

Q1. 
Kevin and His Cards Problem Statement
Kevin has two packs of cards. The first pack contains N cards, and the second contains M cards. Each card has an integer written on it. Determine two results: the tot...read more
Ans. 
Find total distinct card types and common card types between two packs of cards.
• Create a set to store distinct card types when combining both packs.

• Iterate through each pack and add card types to the set.

• Find the intersection of card types between the two packs to get common card types.
Answered by AI
Add your answer
Q2. 
Allocate Books Problem Statement
Given an array of integers arr, where arr[i] represents the number of pages in the i-th book, and an integer m representing the number of students, allocate all the books ...read more
Ans. 
Allocate books to students in a way that minimizes the maximum number of pages assigned to a student.
• Iterate through all possible allocations of books to students.

• Calculate the maximum number of pages assigned to a student for each allocation.

• Return the minimum of these maximums as the result.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

It was a technical round that is based on DSA and computer fundamentals.

Q1. 
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link...read more
Ans. 
Reverse a singly linked list of integers and return the head of the reversed linked list.
• Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.

• Use three pointers - prev, current, and next to reverse the linked list in O(N) time and O(1) space complexity.

• Update the head of the reversed linked list as the last node encountered during the reversal process.
Answered by AI
Add your answer
Q2. 
Sort 0 1 2 Problem Statement
Given an integer array arr of size 'N' containing only 0s, 1s, and 2s, write an algorithm to sort the array.
Input:
The first line contains an integer 'T' representing the n...read more
Ans. 
Sort an array of 0s, 1s, and 2s in linear time complexity.
• Use three pointers to keep track of 0s, 1s, and 2s while traversing the array.

• Swap elements based on the values encountered to sort the array in-place.

• Time complexity should be O(N) and space complexity should be O(1).
Answered by AI
Add your answer