PL-300 Question 43

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  1.) "Change the data type" is correct. We are Talking About the "date" column which is currently formatted as Text (ABC123). In order to transform it to only show the day it must be date. 2.) "Change the data type" is correct as well. The name implies that it should be an amount but it is currently formatted as a date

• 1

  1)Power Query is treating date column as text, not as a real date. You cannot extract day, month, or year from a text column using Date transformations. So before you can transform it to show only the day, you must: change the data type Once the column is converted to Date type, you can use: Transform → Date → Day → Day 2)The column shows: 01/01/1900 02/01/1900 Error This is a classic case where Power Query attempted to convert a value to a Date type but failed because one row contains invalid data. To fix this, you must: change the data type Why? The error is caused by a failed type conversion Re‑assigning the correct data type (or converting using “Using Locale”) resolves the error Renaming the column does nothing Conditional formatting is for visuals, not Power Query

• 2

  In both cases you need to change the data type first