Search test library by skills or roles
⌘ K

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

Skills

Accounting

🧐 Question

Medium

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

Medium

Many-to-one error
Data Modeling
Solve
`Consider the following two tables in Power BI:`
`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:`
`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-***-*****-*’`
```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:`
```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

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

Join 1200+ companies in 75+ countries.
Prova det mest kandidatvänliga utvärderingsverktyget idag.