How should you complete the DAX expression?

HOTSPOT
You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column. pfflag = IF(‘Calendar'[Date] < TOOAYQ, "Past", "Future") You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements: • Returns the fiscal prior year-to-date value for [sales Amount] • Uses a fiscal year end of June 30 • Produces no result for dates in the future How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *