HOTSPOT You have a table that contains a column named Phone. The following is a sample of the data in the Phone column. You need to add a new column that contains the data in the format of nnn-nnn-nnnn. How…
HOTSPOT You are creating reports in Power BI Desktop. The model has the following tables. There is a relationship between the tables. You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.…
DRAG DROP You have a column named phone_number. The values in the columns are in one of the following formats: 999-999-9999×123 1-999-999-9999×232 +1-999-999-9999×667 The values after x in the phone_number column indicate the phone extension. You need to create a…
DRAG DROP You have a Power BI model that contains a table named Sales. Sales has the following three measures: A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is…
You have the following table named Location. The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Click the Exhibit tab.) You need to ensure that the map displays…
HOTSPOT You have a report in Power BI Desktop as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. Note: Each correct selection…
HOTSPOT You have a Power BI model that has the following tables: Product (Product_id, Product_Name) Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address) You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID]) You need to create the…
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,…
DRAG DROP Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of…
DRAG DROP You need to create a measure named YTDPreviousSales that will be used in a table visualization. YTDPreviousSales must show the year-to-date (YTD) sales of the previous year for the same month. A sample of the desired data is…