Exam PL-300 topic 1 question 19 discussion

Correct Answer!

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.

on the exam 11/9/24 and I got this right surprisingly. Pivot does my head in.

In my opinion: 1 - Select Month and MonthNumber columns 2 - Select Unpivot other columns 3 - Rename the attribute column as year and the value column as sales

Correct answer

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

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

answer is correct!

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.

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.

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

That's correct

It's correct!

Provided answer is correct.

Correct. A, B and C