exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 7 discussion

Actual exam question from Microsoft's 70-779
Question #: 7
Topic #: 1
[All 70-779 Questions]

HOTSPOT -
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 the scenario is the same in each question in this series.
Start of repeated scenario.
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.)
Exhibit:

Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a measure named [Sales Monthly RT] that calculates a running total of [Sales] for each date within a month as shown in the following exhibit.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
https://msdn.microsoft.com/en-us/library/ee634557.aspx
http://radacad.com/previous-dynamic-period-dax-calculation

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
thecov
Highly Voted 5 years, 8 months ago
should be CALCULATE and DATESMTD
upvoted 33 times
Samewiss
5 years, 7 months ago
cant be Calculate bc of 2 reasons: 1. the measure already has a hidden calculated, 2. you need any kind of command, meaning what you want to do with the columns
upvoted 1 times
...
...
tho
Highly Voted 5 years, 7 months ago
[Sales] is a measure, so it should be CALCULATE([Sales], DATESMTD(DimDate[Date]))
upvoted 28 times
Agustin
4 years, 11 months ago
Totally right!
upvoted 1 times
...
...
Temmyturpeh
Most Recent 4 years, 5 months ago
DATESBETWEEN requires at least two arguments, start date and end date. so the only correct answer is DATESMTD,
upvoted 2 times
...
CDL
4 years, 8 months ago
Link: https://www.sqlbi.com/articles/computing-running-totals-in-dax/ Example: Sales YTD := CALCULATE ( [Sales Amount], DATESYTD( 'Date'[Date] ) )
upvoted 1 times
...
fabioco
5 years ago
datesbetween function requires three arguments and it does not calculate a running total. The correct answer is CALCULATE, DATESMTD
upvoted 2 times
...
abtsoares
5 years ago
Example for early running total: https://www.sqlbi.com/articles/computing-running-totals-in-dax/
upvoted 4 times
...
bcurtis
5 years, 1 month ago
Correct answer is CALCULATE([Sales], DATESMTD(DimDate[Date])), [Sales] is not a column in the table and is not the table name either so must be a measure. Datesbetween also requires a specified start and end date as part of the argument
upvoted 3 times
...
Chikhalsouk
5 years, 1 month ago
RT:=CALCULATE([Sales],DATESMTD(DimDate[Datekey])
upvoted 2 times
...
lozqt
5 years, 3 months ago
[Sales] is a calculated measure --> Sales = SUM(column_requiered). [Sales Monthly RT] = CALCULATE ([Sales]);DATESMTD(Table_DimensionDate[Column]). This works, I checked if prerequisite are filled. Meaning two Tables are needed, a fact table and a dimension table (for the dates). A Relationship has to exist between both table (1:*) from the dimension table to the fact table. This done, you can create the measure. Hence the GIVEN ANSWER IS WRONG.... It is not SUM.... DATESBETWEEN.
upvoted 3 times
...
NewSec
5 years, 4 months ago
The "expression" argument of CALCULATE cannot be just the measure. On the other hand, DATESADD requires forward or backward period and the indicated argument does not raise it, DATESBETWEEN requires start date and end date and PERIODPARALLEL does not apply. Correct answer: sum ([Sales], DATESMTD (DimDate [Date]))
upvoted 2 times
nose
5 years, 4 months ago
wrong..... the syntax for SUM is "SUM(<column>)"... there is no option to filter https://docs.microsoft.com/en-us/dax/sum-function-dax
upvoted 2 times
...
...
Scarleth02
5 years, 4 months ago
The correct answer is: Sales Monthy RT:=CALCULATE([Sales],DATESMTD(DimDate[Datekey]))
upvoted 2 times
...
SumanthB
5 years, 4 months ago
In order to calculate the Running Total (RT) measure we ought to be using the DATESBETWEEN not DATESTMTD [Ref: https://radacad.com/datesinperiod-vs-datesbetween-dax-time-intelligence-for-power-bi]. Has the question changed or am i not understanding why everyone is pointing towards DATESMTD?
upvoted 1 times
...
iSharaf
5 years, 5 months ago
Sales Monthly RT = CALCULATE(SUM([SalesAmount]), DATESMTD(Date[Datekey])) I tested it, it works Correct answer is SUM & DATESMED
upvoted 2 times
...
Mag53
5 years, 5 months ago
agree to Nishat, it´s the best Solution as [Sales] is no original column in the table FactSales. Irritating: a predefined measure would also show in the data model. So answer should be: Sep 1: create the measure [Sales] 2. CALCULATE([Sales],DATESMTD(DimDate[Date]))
upvoted 2 times
...
Nishant
5 years, 5 months ago
The answer should be: CALCULATE([Sales],DATESMTD(DimDate[Date])) [Sales] is measure here.
upvoted 15 times
...
Mag53
5 years, 6 months ago
Only way it works: CALCULATE(SUM([Sales]); DATESMTD(DimDate[Date])) Question says: how to comlete the DAX formula --> SUM and DATESMTD is correct. About difference between SUM and SUMX check: https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi
upvoted 5 times
...
Samewiss
5 years, 7 months ago
should be SUMX and DatesMTD
upvoted 1 times
ammu
5 years, 7 months ago
How can it be sumx? Sumx needs table name as its 1st parameter, and this DAX formula isnt showing any table name.
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...