WorksheetsPower BI Relationships and DAX Quiz
Total questions: 21
Worksheet time: 11mins
How would you display a value as a percentage using DAX?
By using the DIVIDE function
By using the FORMAT function
By using the SUM function
By using the COUNT function
What is the primary purpose of establishing relationships between tables in Power BI?
To delete unnecessary data
To connect data from different tables for analysis
To create visualisations
To format data as currency
Which type of relationship is commonly used in a star schema?
Many-to-many
One-to-one
One-to-many
Self-referencing
What is the function of the DAX formula `SUM`?
To count unique values
To add up all the values in a column
To find the minimum value
To calculate the average
Which DAX function would you use to calculate the number of unique accounts?
COUNT
DISTINCTCOUNT
SUM
MAX
What is the main difference between calculated columns and measures in Power BI?
Calculated columns are used for formatting, measures are not
Calculated columns are static, measures are dynamic
Measures are used for text data, calculated columns are not
Measures are used for creating relationships, calculated columns are not
Which DAX function would you use to perform a conditional sum?
FILTER
CALCULATE
DIVIDE
SWITCH
Which visualisation would you use to display a single value in Power BI?
Table
Card visual
Line chart
Pie chart
Which DAX function is similar to Excel’s VLOOKUP?
RELATED
RANKX
SWITCH
IF
What is the purpose of the RANKX function in Power BI?
To create a new table
To rank values in ascending or descending order
To calculate totals
To format data
What is the benefit of organising data into a star schema?
It reduces the size of the data
It simplifies data modelling and improves performance
It allows for more complex calculations
It automatically creates visualisations
Which DAX function would you use to find the maximum value in a column?
MIN
MAX
SUM
COUNT
What is the purpose of using the SWITCH function in DAX?
To perform arithmetic operations
To apply conditional logic
To format data
To create relationships
How can you delete default relationships in Power BI to start fresh?
By using the FORMAT function
By using the Model view
By using the Data view
By using the Visualisation pane
Which DAX function would you use to divide two numbers and handle division by zero?
SUM
DIVIDE
CALCULATE
FILTER
What is the purpose of the CALCULATE function in DAX?
To create a new table
To filter data based on conditions
To rank values
To format data
Which DAX function would you use to concatenate two text strings?
CONCATENATE
MAX
SUM
DIVIDE
What is the function of the DAX formula 'AVERAGE'?
To find the maximum value
To count the number of rows
To calculate the average of values in a column
To find the sum of values
What is the purpose of the FILTER function in DAX?
To format data as text
To create a new table
To filter a table based on a condition
To calculate the sum of values
Which visualisation is best for showing trends over time in Power BI?
Card visual
Line chart
Pie chart
Bar chart
Which DAX function is used to return the first value in a column?
FIRSTNONBLANK
MIN
MAX
LASTNONBLANK
