Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 19

DRAG DROP

-

You receive annual sales data that must be included in Power BI reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

You need to create a report that meets the following requirements:

• Visualizes the Sales value over a period of years and months

• Adds a slicer for the month

• Adds a slicer for the year

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    Correct Answer:

Discussion
GuerreiroJunior

Correct Answer!

Igetmyrole

Here are the correct three actions should be performed in sequence: Action 1: Select the Month and MonthNumber Columns. These columns will be used for the slicers to filter the data by month. Action 2: Select unpivot other columns. This action will transform the 2019, 2020, and 2021 columns into rows, creating a column called "Attribute" that contains the years and a column called "Value" that contains the sales data. This step makes the data more suitable for visualization and filtering by year. Action 3: Rename the Attribute column as Year and the value column as sales. Renaming the columns provides a more descriptive and meaningful structure for your data. After performing these actions, your data will be in a format that allows you to create visuals and add slicers for the month and year in Power BI.

semauni

Answer is correct! Transpose would cause the rows and columns to swap, so the months would become columns and the years would become rows. And, as another person here already stated, for an Unpivot you select the columns that you would like to remain the same, not the rows you want transformed.

panic_attack

This was also on the exam on 22/2/2024 (:

nick0651

given exam on 21th Oct 2023 , This Question is in the exam . I scored 79 , No need to take ful version most of the question covern under 24 pages only.

AdrianBalescu

actually it helps a lot by taking the full version, it is the only website with forum community for all the questions, helps to analyze the right answer.

AKUMAR2104

This was on exam Today

venupurna

This was in the exam today.

spamhz

i was tricked by "unpivot OTHER COLUMNS" do take note!

Shalaleh

answer is correct!

DUVANES

1. Seleccione las columnas Mes y MonthNumber. 2. Seleccione Despivotar otras columnas. 3. Cambie el nombre de la columna de atributos as Año y la columna Valor a Ventas.

mtvl123

It's correct!

Kiran37

Correct answer

ET_phone_home_son

Select Month & MonthNo > Unpivot other columns > Rename attribute (Year) and values (Sales)

Heshybay

The first action is to select the columns for 2019, 2020, and 2021.

pisanoagus

Not really. You first select the first two columns, then unpivot other columns (which are the year columns) Then you rename the output

apher

That's correct

jsking

Provided answer is correct.

JoaoTrade

Correct. A, B and C