How should you complete the measure?

Posted by: Pdfprep Category: 70-778 Tags: , ,

DRAG DROP

You need to create a measure named YTDPreviousSales that will be used in a table visualization. YTDPreviousSales must show the year-to-date (YTD) sales of the previous year for the same month. A sample of the desired data is shown in the following table.

How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Answer:

Explanation:

References:

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

Leave a Reply

Your email address will not be published.