Welcome to your Power Bi/Power Query
1.
Which tool is used for data transformation in Power BI?
2.
Which language is used for writing custom expressions in Power Query?
3.
What is the purpose of the "Remove Duplicates" transformation in Power Query?
4.
Which function is used to merge two tables based on matching values in Power Query?
5.
What does the "Group By" transformation do in Power Query?
6.
Which option allows you to unpivot columns in Power Query?
7.
What is the purpose of the "Conditional Column" feature in Power Query?
8.
Which option is used to load data into the Power BI data model after transforming it in Power Query?
9.
Which transformation is used to extract specific parts of a text string in Power Query?
10.
What does the "Change Type" transformation do in Power Query?
11.
Which function is used to create a custom column using the Advanced Editor in Power Query?
12.
What is the purpose of the "Replace Values" transformation in Power Query?
13.
Which option is used to refresh data in Power Query to reflect changes in the source data?
14.
What does the "Merge Queries" feature allow you to do in Power Query?
15.
Which function is used to filter rows based on specified conditions in Power Query?
16.
What is the purpose of the "Split Column" transformation in Power Query?
17.
Which option allows you to promote headers in Power Query?
18.
What does the "Fill Down" transformation do in Power Query?
19.
Which function is used to calculate a running total in Power Query?
20.
What does the "Expand" option do in Power Query?
Leave a Reply