Scribd
Upload
41 views1 page

Power Query Tasks 1

Uploaded by

palanivel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
41 views1 page

Power Query Tasks 1

Uploaded by

palanivel
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Power Query Tasks

1. How would you split the FullName column into two separate columns for first and last names?

2. Which steps would you take to remove the Status column from the dataset?

3. How can you calculate the average salary for each Department?

4. What steps would you use to replace all occurrences of 'Tamil Nadu' in the Region column
with 'TN'?

5. How can you sort the dataset by Salary in descending order?

6. How would you keep only the top 5 rows with the highest salaries?

7. If the dataset loads without proper headers, how would you promote the first row to become
headers?

8. How can you remove duplicate rows from the dataset?

9. How would you change the data type of the JoinDate column to Date?

10. How can you combine this dataset with another table containing region-wise manager

names using the Region column?

You might also like