Power BI - Getting Data
After importing an Excel sheet with columns Date, Sales, and Region, which Power BI step creates a new column 'Year' from 'Date'?
After importing an Excel sheet with columns Date, Sales, and Region, which Power BI step creates a new column 'Year' from 'Date'?
medium📝 Formula Result Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Locate the correct Power Query action
To extract the year from a Date column, use Add Column > Date > Year in Power Query Editor.Step 2: Exclude incorrect steps
Transform > Data Type changes data type, not extracts year. Close & Apply saves changes. Model > New Measure creates measures, not columns.Final Answer:
Add Column > Date > Year -> Option BQuick Check:
Create year column = Add Column > Date > Year [OK]
Quick Trick: Use Add Column > Date > Year to extract year [OK]
Common Mistakes:
- Changing data type instead of extracting year
- Trying to create a measure instead of a column
- Skipping Add Column step
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes