Q30
Hotspot
HOTSPOT
You use Power Query Editor to pull data from a Microsoft SharePoint Online list.
You plan to use Advanced Editor to build a Power Query M formula language query.
You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Select the correct area(s) on the image.
