Exam 70-778 topic 2 question 8 discussion

Answer is correct

Answer is "C". Here you need to calculate your sales in the last 12 month. "How much did you sale in the last 12 month".which evaluates to my (current sales) - (sales from 12 month ago). For ex: if you had 10$ after 12 month you have 100$ so how much did you gain in the last 12 month ? (100 "current" - 10 "started with from 12 month") so you gained 90$ in this period. Hope it helps.

Strange question, or is somehting missing in the text ? Given a Date D1 (15/12/2012), C is calculating the difference between SalesAmount for D1 and SalesAmount of the D1 of last year (15/12/2011). B also is only giving SalesAmount of the D1 of last year (15/12/2011). None of the options are giving SalesAmount for last 12 months of a given date (Rolling 12 months). In my sens, to calculate total sales of last 12 months (rolling 12 months), we should use something like following DAX formula : CALCULATE ( SUM ( 'Sales'[SalesAmount] ), DATESINPERIOD('Date'[Date], LASTDATE('Date'[Date]), -12, MONTH))

I go with C. Think it thru via a example. Let’s say it’s Apr, last 12 month means current year to date Jan to Apr PLUS last years (12-4=8 months) from May to Dec, which means last whole year sum amount minus same period last year’s “sum amount”. BTW, YTD function usually is used to compute “Running total”

Definitely B

As i understand this...If the current context is april 2019, it must calculate the sale from 1. may 2018 to 30. april 2019. If the current context is Q3 2019, a measure must calculate the sale from 1. october 2018 to 30. september 2019, and so on. So, i created my own measure and tested it. The test was successful. Last12MonthSaleAmount = var enddate = LASTDATE('Date'[Date]) var startdate = DATEADD(enddate, -1, year) return CALCULATE(sum(Sales[SalesAmount]), DATESBETWEEN('Date'[Date], startdate + 1, enddate)) In this example, i use the DATEADD and DATESBETWEEN function. You can use other functions instead: DATEADD >> SAMEPERIODLASTYEAR DATESBETWEEN >> DATESINPERIOD It will return the same result. If anyone claims that there is a correct answer, please give us a complete solution that returns the correct result. Not just say which answer is correct. I don't believe any of you, until the statement is proved by fact. My conclusion: --------------- I think the answers are not compatible with the task.

There is no correct answers.

Sales (Selected Month) = SUM ( Sales[Sales] ) Sales Last Year = CALCULATE ( SUM ( Sales[Sales] ), SAMEPERIODLASTYEAR ( ‘Date'[Date] ) ) Sales YTD = TOTALYTD ( SUM ( Sales[Sales] ), ‘Date'[Date] )

The correct Answer is B

Measure B gives a sum of previous year's sales, which is incorrect in this scenario. Measure C gives a sum of sales for last 12 months, which is correct calculation for every date. I've tested it. I didn't believe, but answer C is really correct and B is definately not.

Answer is B Example The following sample formula creates a measure that calculates the previous year sales of Reseller sales. DAX Copy =CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]), SAMEPERIODLASTYEAR(DateTime[DateKey]))

The answer is B. Look at the example in the link: https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Need to create a measure to calculate the sales for the last 12 months (Answer explained) https://community.powerbi.com/t5/Desktop/Need-to-create-a-measure-to-calculate-the-sales-for-the-last-12/m-p/721893#M348422

Can we use time intelligence measures when the relation is on date_id and not an a date column?

I agree, the answer is correct.

It should be B

Is this answer ok????