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. DATESYTD. https://powerpivotpro.com/2016/01/year-to-date-in-previousprior-year/

Model and Visualize Data by Using Power BI Desktop

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

ADATEADD
BTOTALYTD
CDATESYTD
DENDOFYEAR

How the community answered

(41 responses)

A
15% (6)
B
7% (3)
C
73% (30)
D
5% (2)

Explanation

https://powerpivotpro.com/2016/01/year-to-date-in-previousprior-year/

Topics

#DAX#DATESYTD#time intelligence#year-to-date

Community Discussion

No community discussion yet for this question.

Full 70-778 Practice