Bird
0
0

You need to combine sales data from two different sources with different column names for date and amount. What is the best approach in Power BI?

hard📝 Scenario Q9 of 15
Power BI - Basics and Architecture
You need to combine sales data from two different sources with different column names for date and amount. What is the best approach in Power BI?
AExport data to Excel and combine manually
BCreate separate reports for each source
CWrite a DAX formula to merge the tables
DUse Power Query to rename columns and append the tables
Step-by-Step Solution
Solution:

  1. Step 1: Prepare data for combination

    Rename columns in Power Query so both tables have matching column names.

  2. Step 2: Append tables in Power Query

    Appending merges rows from both tables into one combined table.

  3. Final Answer:

    Use Power Query to rename columns and append the tables -> Option D

  4. Quick Check:

    Power Query renaming + append = combined data [OK]
Quick Trick: Rename columns then append tables in Power Query [OK]
Common Mistakes:
  • Trying to merge with DAX
  • Keeping different column names before append

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Map visualizations - Quiz 6medium Basic Visualizations - Card and multi-row card - Quiz 4medium Data Cleaning with Power Query - Unpivoting columns - Quiz 13medium Getting Data - Multiple data sources in one report - Quiz 2easy Getting Data - Web data import - Quiz 12easy Power BI Basics and Architecture - Interface overview (Report, Data, Model views) - Quiz 6medium Power BI Basics and Architecture - Interface overview (Report, Data, Model views) - Quiz 14medium Power Query Editor - Applied steps and undo - Quiz 10hard Power Query Editor - Why data transformation ensures quality - Quiz 11easy Power Query Editor - Data type changes - Quiz 13medium