Search test library by skills or roles
⌘ K

Adaface Sample Power BI Questions

Here are some sample Power BI questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Default summarization
Data Visualisation
Solve
Review the following table in Power BI:
 image
Here’s the visualisation generated when Book and ReadingChallenges columns are added to a table visualisation:
 image
Why do we see only 4 rows?

Medium

Many-to-one error
Data Modeling
Solve
Consider the following two tables in Power BI:
 image
We received the following error when we tried to set many-to-one cardinality between devices to users tables: “The cardinality you selected isn’t valid for this relationship”. What should we do before creating the many-to-one relationship?

Medium

Power Query Functions
Power Query
Solve
Review the following Microsoft SQL Server table:
 image
Complete the following Power Query formula used to create a custom column to replace the numbers present in last 11 characters of ISBN with 11 ‘*’. Example ‘978-0-365-51051-4’ is converted to ‘978-0-***-*****-*’
 image
A: Text.Insert
            B: Text.Replace
            C: Text.Start
            D: Text.End

Easy

DAX
Solve
We want to create a DAX formula in Power BI that automatically calculates the previous month number. If month is May, the formula would return 4. We have already created the DAX formula: 
Today Month = MONTH (Sales[Todays Date])
Which of the DAX formulas below would be the right choice next?
A: Previous Month = Sales[Today Month]-1
            B: Previous Month = PREVIOUSMONTH(Sales[Today Month])
            C: Previous Month = STARTOFMONTH(Sales[Today Month])-1
            D: Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) (correct)

Medium

Sample data in Power BI
Power Query
Solve
Consider the following Microsoft SQL Server tables:
 image
Which of the following will enable us to import sample data from Sales table in Power BI Desktop?
            
            A: Query Editor → Filter table by Sale Date
            B: Power BI Model → Create a calculated table
            C: Query Editor → Create a custom column using sample function
            D: Query Editor → Add SELECT statement with WHERE clause on Date
🧐 Question🔧 Skill

Medium

Default summarization
Data Visualisation
2 mins
Power BI
Solve

Medium

Many-to-one error
Data Modeling
2 mins
Power BI
Solve

Medium

Power Query Functions
Power Query
2 mins
Power BI
Solve

Easy

DAX
3 mins
Power BI
Solve

Medium

Sample data in Power BI
Power Query
2 mins
Power BI
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Default summarization
Data Visualisation
Power BI
Medium2 mins
Solve
Many-to-one error
Data Modeling
Power BI
Medium2 mins
Solve
Power Query Functions
Power Query
Power BI
Medium2 mins
Solve
DAX
Power BI
Easy3 mins
Solve
Sample data in Power BI
Power Query
Power BI
Medium2 mins
Solve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
Join 1200+ companies in 75+ countries.
今日、最も候補者のフレンドリーなスキル評価ツールをお試しください。
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
私たちとしゃべる
40 min tests.
No trick questions.
Accurate shortlisting.
Ada
Ada
● Online
Previous
Score: NA
Next
✖️