You have a Power BI model that contains a table named Date. The Date table contains the following columns: • Date • Fiscal Year • Fiscal Quarter • Month Name • Calendar Year • Week Number • Month Number • Calendar Quarter You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and…

QuestionsCategory: PL-300You have a Power BI model that contains a table named Date. The Date table contains the following columns: • Date • Fiscal Year • Fiscal Quarter • Month Name • Calendar Year • Week Number • Month Number • Calendar Quarter You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and…
Admin Staff asked 7 months ago
You have a Power BI model that contains a table named Date. The Date table contains the following columns:
•	Date
•	Fiscal Year
•	Fiscal Quarter
•	Month Name
•	Calendar Year
•	Week Number
•	Month Number
•	Calendar Quarter
You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.
Which DAX function should you include in the table definition?

A. ADDCOLUMNS

B. CALCULATE

C. SUMMARIZE

D. DATATABLE








 

Suggested Answer: A



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.

Next Post

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.