- Home
- Microsoft
- Analyzing and Visualizing Data with Power BI
- Microsoft.70-778.v2019-09-10.q76
- Question 30
Valid 70-778 Dumps shared by ExamDiscuss.com for Helping Passing 70-778 Exam! ExamDiscuss.com now offer the newest 70-778 exam dumps, the ExamDiscuss.com 70-778 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-778 dumps with Test Engine here:
Access 70-778 Dumps Premium Version
(155 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 30/76
You have a Power BI model that contains the following tables:
* Sales (Sales_ID, DateID, sales_amount)
* Date (DateID, Date, Month, week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?
* Sales (Sales_ID, DateID, sales_amount)
* Date (DateID, Date, Month, week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?
Correct Answer: C
Explanation
References:
https://msdn.microsoft.com/en-us/library/ee634825.aspx
https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics
https://msdn.microsoft.com/en-us/library/ee634972.aspx
References:
https://msdn.microsoft.com/en-us/library/ee634825.aspx
https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics
https://msdn.microsoft.com/en-us/library/ee634972.aspx
- Question List (76q)
- Question 1: You plan to use Power BI Desktop to create a report. The rep...
- Question 2: You open powerbi.com as shown in the following exhibit. Use ...
- Question 3: You use Power BI Desktop to create a visualization for a Mic...
- Question 4: You have a Microsoft Excel spreadsheet that contains a table...
- Question 5: Note: This question is part of a series of questions that us...
- Question 6: You need to create a dashboard in the Power BI service to di...
- Question 7: You plan to create a Power BI report. You have the schema mo...
- Question 8: You have a Power BI model for sales data. You need to create...
- Question 9: You have an on-premises Power BI Report Server. You plan to ...
- Question 10: Note: This question is part of a series of questions that pr...
- Question 11: Note: This question is a part of a series of questions that ...
- Question 12: Note: This question is part of a series of questions that pr...
- Question 13: You have a Power BI report that is configured to use row-lev...
- Question 14: You plan to develop a Power BI report that has a bar chart t...
- Question 15: You are creating reports in Power BI Desktop. The model has ...
- Question 16: You have the following two tables: * Subscriber (Subscriberl...
- Question 17: You have a Microsoft SQL Server Analysis Services (SSAS) cub...
- Question 18: Note: This question is part of a series of questions that pr...
- Question 19: Note: This question is a part of a series of questions that ...
- Question 20: Note: This question is a part of a series of questions that ...
- Question 21: Note: This question is part of a series of questions that us...
- Question 22: You plan to use Power BI Desktop optimized for Power BI Repo...
- Question 23: You are creating a report in Power BI Desktop that has two v...
- Question 24: You have a Power BI report that displays a bar chart and a d...
- Question 25: Note: This question is part of a series of questions that pr...
- Question 26: You have a power BI model that contains the following tables...
- Question 27: You have the following tables. (Exhibit) You need to create ...
- Question 28: You have a Power BI Desktop project that uses DirectQuery to...
- Question 29: You have a Microsoft Excel 2016 workbook that has a Power Pi...
- Question 30: You have a Power BI model that contains the following tables...
- Question 31: Note: This question is a part of a series of questions that ...
- Question 32: You attempt to publish a Microsoft Excel file to Power BI, a...
- Question 33: Your company plans to use Power BI for 20 users in the sales...
- Question 34: Note: This question is a part of a series of questions that ...
- Question 35: You have a table that contains a column named Phone. The fol...
- Question 36: You have three Power BI Desktop projects named Reportl.pbix,...
- Question 37: From the Home tab in Power BI Desktop, you click Enter Data ...
- Question 38: You have a query that uses a Microsoft Excel data source. Th...
- Question 39: Note: This question is part of a series of questions that us...
- Question 40: You have a sales report in an app workspace. The report disp...
- Question 41: You have a query that retrieves sales data. A sample of the ...
- Question 42: You have a Power BI model that contains a table named Sales....
- Question 43: You have a table named Sales. Sales contains the data shown ...
- Question 44: Note: This question is a part of a series of questions that ...
- Question 45: Note: This question is a part of a series of questions that ...
- Question 46: You have a query named FactlnternetSales used by several Pow...
- Question 47: Note: This question is a part of a series of questions that ...
- Question 48: You embed a Power BI report in a Microsoft SharePoint Online...
- Question 49: Note: This question is part of a series of questions that us...
- Question 50: You are creating a work schedule for a retail store. You hav...
- Question 51: You create a new app workspace. You add a user named Userl1 ...
- Question 52: Note: This question is part of a series of questions that pr...
- Question 53: You have a service published to a website. When you connect ...
- Question 54: Note: This question is part of a series of questions that pr...
- Question 55: Note: This question is a part of a series of questions that ...
- Question 56: You have the following two queries in Power BI Desktop: * A ...
- Question 57: You plan to deploy a Power BI app workspace that will be vie...
- Question 58: You have a Microsoft Excel workbook that contains two tables...
- Question 59: From Power BI Desktop, you publish an app that contains one ...
- Question 60: You have the report shown in the following exhibit. (Exhibit...
- Question 61: You open the Power BI Admin portal as shown in the following...
- Question 62: You have a Power BI app named App1. The privacy for the App1...
- Question 63: Note: This question is part of a series of questions that us...
- Question 64: You create a report in Power BI Desktop. You need to embed t...
- Question 65: Note: This question is part of a series of questions that pr...
- Question 66: You have a Power BI report in an app workspace. You plan to ...
- Question 67: You create a dashboard that displays the results of a custom...
- Question 68: You create a report in the Power BI service that displays th...
- Question 69: You have a column named phone_number. The values in the colu...
- Question 70: Note: This question is part of a series of questions that pr...
- Question 71: You create a KPI visualization in Power BI Desktop that uses...
- Question 72: Note: This question is a part of a series of questions that ...
- Question 73: You have the datasets shown in the following graphic. (Exhib...
- Question 74: You are creating a report in Power BI Desktop. You are consu...
- Question 75: Your company has a security policy stating that proprietary ...
- Question 76: You have two tables named CustomerVisits and Date in a Power...
