Microsoft
70-778 · Question #124
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which…
The correct answer is C. SAMEPERIODLASTYEAR. See the full explanation below for the reasoning.
Question
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same time period. Which DAX function should you use?
Options
- ALASTDATE
- BTOTALYTD
- CSAMEPERIODLASTYEAR
- DPREVIOUSYEAR
How the community answered
(24 responses)- A4% (1)
- B8% (2)
- C75% (18)
- D13% (3)
Community Discussion
No community discussion yet for this question.