HOTSPOT - You have a Power BI model that contains the following data. The Date table relates to the Sales table by using the Date columns. You need to create a calculated table that will contain the following: • A row for each year • A column that contains the total sales per year How should you complete the DAX calculation? To answer, select the appropriate options in the answer...

Questions › Category: PL-300 › HOTSPOT – You have a Power BI model that contains the following data. The Date table relates to the Sales table by using the Date columns. You need to create a calculated table that will contain the following: • A row for each year • A column that contains the total sales per year How should you complete the DAX calculation? To answer, select the appropriate options in the answer…

0 Vote Up Vote Down

Admin Staff asked 4 months ago

HOTSPOT
-
You have a Power BI model that contains the following data.
 
The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that will contain the following:
•	A row for each year
•	A column that contains the total sales per year
How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 
















 

Suggested Answer: 
    



This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.