Quizalize logo
placeholder image to represent content

How to use SELECTCOLUMNS and ADDCOLUMNS

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    What does the Select Columns function do in Power BI?
    Creates a new column within an existing table.
    Filters data in an existing table.
    Modifies data types of columns in an existing table.
    Creates a new table by selecting specific columns from existing tables and optionally adding new calculated columns.
    30s
  • Q2
    What are the minimum parameters required to use the Select Columns function?
    1. The table to use. 2. A filter expression.
    1. The table to use. 2. The name of the new column to be added. 3. The expression for the value in the new column.
    1. The table to use. 2. A sorting expression.
    1. The table to use. 2. The name of the existing column to be modified.
    30s
  • Q3
    How can you access columns from a related table in the Select Columns function?
    By using the RELATED function.
    By specifying the relationship name in the Select Columns function.
    By creating a calculated column that joins the tables.
    By merging the tables before using Select Columns.
    30s
  • Q4
    What is the main difference between Select Columns and Add Columns functions?
    Select Columns allows you to specify which columns to bring into the new table, while Add Columns automatically brings all columns from the original table.
    There is no difference between these functions.
    Select Columns is used for creating new tables, while Add Columns is used for modifying existing tables.
    Select Columns can only be used with numerical data, while Add Columns can be used with all data types.
    30s
  • Q5
    What is a good use case for the Add Columns function?
    When you only want to select specific columns from an existing table.
    When you want to modify data types of columns in an existing table.
    When you want to filter data in an existing table.
    When you want to bring all the original columns into a new table and also add new calculated columns, especially when there are many original columns.
    30s
  • Q6
    What are some common uses of the Select Columns function?
    1. Generating calendars using DAX. 2. Appending data from multiple tables using the UNION function.
    1. Creating hierarchies in a Power BI model. 2. Transposing rows and columns in a table.
    1. Formatting the appearance of data in a table. 2. Setting data security permissions.
    1. Creating measures in a Power BI model. 2. Managing relationships between tables.
    30s
  • Q7
    How do you ensure that the UNION function works correctly when appending data using Select Columns?
    By making sure the number and names of columns match exactly in both tables.
    By sorting the data in both tables before appending.
    By filtering out any unnecessary rows from the tables before appending.
    By setting the data types of all columns to be the same.
    30s
  • Q8
    In this video, what was the name given to the new DAX table created using the Select Columns function?
    NewTable
    Orders (SC)
    OrderDetails Extended
    Total Sales
    30s
  • Q9
    What was the purpose of the Total Sales column added in the video?
    To show the average unit price across all orders.
    To calculate the total sales for each order by multiplying the quantity by the unit price.
    To display the total number of orders in the table.
    To store the sum of all sales in the table.
    30s
  • Q10
    What did the instructor recommend viewers do if they didn't understand the concepts in the video?
    Watch the video again at a slower speed.
    Search for the concepts online.
    Contact Microsoft support.
    Ask questions in the comment section below the video.
    30s

Teachers give this quiz to your class