Posted by: Pdfprep
Post Date: November 3, 2020
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?
A . DATEADD
B . TOTALYTD
C . DATESYTD
D . ENDOFYEAR
Answer: C
Explanation:
References:
https://powerpivotpro.com/2016/01/year-to-date-in-previousprior-year/
Leave a Reply