You have a CSV file with inconsistent date formats in the 'Date' column (e.g., '2023-01-01' and '01/02/2023'). How should you handle this in Power BI to ensure correct date import?

hard📝 Scenario Q8 of 15

Power BI - Getting Data

AImport as text and use DAX to convert dates later

BDelete rows with inconsistent dates before import

CIgnore the issue; Power BI will auto-correct dates

DUse Power Query to split and transform dates into a consistent format before loading

Step-by-Step Solution

Solution:

Step 1: Recognize inconsistent date formats cause import errors
Power BI may misinterpret dates if formats vary within the same column.
Step 2: Use Power Query to clean and standardize dates
Transform dates in Power Query by splitting, parsing, and converting to a single consistent date format.
Final Answer:
Use Power Query to split and transform dates into a consistent format before loading -> Option D
Quick Check:
Fix inconsistent dates in Power Query before loading = B [OK]

Quick Trick: Clean and standardize dates in Power Query for reliable import [OK]

Common Mistakes:

Relying on auto-correction by Power BI
Using DAX instead of Power Query for date fixes
Deleting data instead of cleaning

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You have a CSV file with inconsistent date formats in the 'Date' column (e.g., '2023-01-01' and '01/02/2023'). How should you handle this in Power BI to ensure correct date import?

Step 1: Recognize inconsistent date formats cause import errors

Step 2: Use Power Query to clean and standardize dates

Final Answer:

Quick Check:

Want More Practice?