Exam PL-300 topic 1 question 44 discussion

Actual exam question from Microsoft's PL-300

Question #: 44
Topic #: 1

HOTSPOT
-

You are using Microsoft Power BI Desktop to profile data in Power Query Editor.

Table data is displayed as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Pitxunet at Feb. 10, 2025, 1:31 p.m.

Comments

Submit Cancel

Pitxunet

Highly Voted 4 months, 2 weeks ago

In both cases you need to change the data type first

upvoted 19 times

...

Idmir

Most Recent 1 month ago

cambiar el tipo de datos para dos preguntas

upvoted 1 times

...

lechuc508

1 month, 2 weeks ago

change the data type forr two questions

upvoted 1 times

...

larahm

2 months, 2 weeks ago

cambiar tipo de datos en ambos casos

upvoted 1 times

...

Mi4as

3 months, 1 week ago

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.

upvoted 2 times

...

langarz

4 months, 1 week ago

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

upvoted 1 times

...

Zander3

4 months, 1 week ago

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.

upvoted 1 times

...