Power BI day2 FN

What does the "Remove Errors" option in Power BI primarily do?

• Deletes all rows in the dataset

• Removes rows containing errors in specific columns

•  Highlights the rows with errors

• Removes duplicate rows

When applying the "Remove Errors" function, where can you find details of the removed rows?

•  In the Query Dependencies view
  

• In the Errors pane
  

•  In the Applied Steps pane
  

• In the Data View
  

Which of the following scenarios can cause errors in Power Query?

•  Division by zero
  

•  Data type mismatch
  

•  Invalid date format
  

• All of the above
  

What is the best approach to handle errors in Power BI instead of removing them?

• Replace errors with null values
  

• Remove rows with errors
  

• Ignore errors

• Change the data type
  

Which tool in Power Query is used to add a new column based on a formula?

•  Add Column
  

•  Conditional Formatting
  

•  Applied Steps

• Transform Column
  

What type of column would you create to generate values like "High," "Medium," or "Low" based on a numeric field?

•  Custom Column
  

• Conditional Column
  

• Duplicate Column
  

• Grouped Column
  

Which language is used to write custom column formulas in Power BI?

• DAX
  

•  M Language
  

• SQL
  

•  Python
  

Which tab in Power Query contains the "Merge Columns" option?

• Transform
  

• Add Column
  

• Home
  

• View

  
  

What is a "Custom Column" in Power BI?

• A duplicate of an existing column
  

•  A column created based on user-defined formulas
  

• A column automatically generated by Power BI
  

• A column imported from an external dataset
  

Which tab contains the "Custom Column" option in Power Query?

•  Add Column
  

•  Transform
  

• Home
  

• View