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:
