Exam PL-300 topic 1 question 44 discussion

In both cases you need to change the data type first

cambiar tipo de datos en ambos casos

Completely wrong options for answers, and no one gave the result = day number. We can do this in a step: = Table.TransformColumns(#"Changed Type",{{"Date.Entries.menuAmount", Date.Day, Int64.Type}}) So just click RM - transform - Day - Day = done, and you will get day number and Integer data type in one GO. First block: A) Change datatype. I tried to do that and any manipulation didn't return the date as datetype or day from the error value. B) Parse we don't have it under the column. This is available only for text datatype (we have date datatype) or for xml/json file (under transformation tabe - not a column menu). C) Replace Value - not a Replace Error. The second block either hasn't suitable option.

Power Query (M language) does not have a built-in PARSE function like in SQL or DAX

Date column -Use the Parse command on the column-The parse command takes a text string and breaks it down into structured parts. If a column contains concatenated values, text with delimiters, you would use the Parse to split or extract the specific components you need for analysis. data.Entries.menu.Amount column- Change data type-In Power BI, the date value "01/01/1900" represents a zero value. To fix this, change the data type to a numeric type (such as Decimal Number or Whole Number). This adjustment should display the correct amounts and eliminate the errors.