Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 73 discussion

Actual exam question from Microsoft's PL-300
Question #: 73
Topic #: 2
[All PL-300 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by [deleted] at Aug. 5, 2023, 6:35 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Pocu
Highly Voted 1 year, 2 months ago
I wanna say that again. Comment and vote carefully before you have actually done some research otherwise It will cause confusion to other people. The answer is Summarize. UniqueCalendarTable = SUMMARIZE( Date, 'Date'[Calendar Year], 'Date'[Calendar Quarter], 'Date'[Month Name] )
upvoted 82 times
zanbeel
7 months ago
SUMMARIZE may provide the sum of quarter no?
upvoted 1 times
...
AyoJose
1 year, 1 month ago
"Comment and vote carefully before you have actually done some research" or after you've actually done some research?
upvoted 17 times
...
...
Badadadiiii
Highly Voted 1 year, 3 months ago
Selected Answer: C
Should be Summarized
upvoted 12 times
...
jaume
Most Recent 6 days, 12 hours ago
Selected Answer: C
ADDCOLUMNS(<table>, <column name>, <expression>, [...]) would create a table with ADDITIONAL computed columns DATATABLE(<column names and types>, <data>) would create a table by explicitely defining rows and columns SUMMARIZE(<table>, <groupBy_columnName>, [...], [<name>, <expression>]...) would perform a GROUP BY operation, aggregating data based on specified columns and optional expressions
upvoted 1 times
...
SIH007
6 months, 3 weeks ago
Thank you for your solution, Pocu, it helped a lot!
upvoted 3 times
...
Rhugved
8 months, 3 weeks ago
Selected Answer: C
Summarize is the correct answer!
upvoted 3 times
...
[Removed]
9 months ago
Selected Answer: C
Should be Summarized
upvoted 1 times
...
Dani_eL
9 months, 1 week ago
Selected Answer: C
AddColumns creates a new table including ALL FIELDS from the selected table AND ADD new columns to it based on parameters Summarize creates a new EMPTY table using the table name given as first parameter and including the fields parameters that Intellisense is giving you SUMMARIZE is the function to use
upvoted 3 times
...
DOUNIA
1 year ago
Selected Answer: C
It must be C not A
upvoted 1 times
...
umairtaqi
1 year, 2 months ago
Selected Answer: A
A is the correct answer I have tested.
upvoted 1 times
tranquanghuy2111
1 year, 1 month ago
Nope, ADDCOLUMNS will add additional column to given table. Therefore, outcome is given table with all its original columns and the added ones. But the question only requires 3 columns. --> SUMMARIZE is correct answer here
upvoted 5 times
...
...
LeeLee_105
1 year, 3 months ago
Selected Answer: C
https://youtu.be/VurpXBcbrT0
upvoted 4 times
...
Shirl_Nina
1 year, 3 months ago
ADDCOLUMNS is correct. It Adds calculated columns to the given table or table expression whereas SUMMARIZE Returns a summary table for the requested totals over a set of groups.
upvoted 3 times
...
Bamlaku
1 year, 3 months ago
Selected Answer: D
The DATATABLE function in DAX allows you to create a calculated table. The calculated table can be based on any data source, including the Date table. To create a calculated table that contains only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month, you can use the following DAX code:
upvoted 1 times
5d477b6
2 months, 1 week ago
DATATABLE: This function allows you to manually define a table by specifying column names and rows, but it’s not used for summarizing an existing table.
upvoted 1 times
...
...
sergeyitaly
1 year, 3 months ago
Addcolumns does not create a new table, but Summarize does create it
upvoted 3 times
...
mohanonly1
1 year, 3 months ago
SUMMARIZE should be the answer
upvoted 3 times
...
pverde
1 year, 3 months ago
Selected Answer: C
I think it should be SUMMARIZE SUMMARIZE: "Creates a summary of the input table grouped by the specified columns." ADDCOLUMNS: "Returns a table with new columns specified by the DAX expressions." Based on this, using SUMMARIZE will give us the unique combination we want and don't need to use DAX expressions to create the calculated table.
upvoted 7 times
...
Krishna1807
1 year, 3 months ago
The correct answer should be SUMMARIZE
upvoted 1 times
...
[Removed]
1 year, 3 months ago
Selected Answer: C
CalculatedTable = SUMMARIZECOLUMNS( 'Date'[Calendar Year], 'Date'[Calendar Quarter], 'Date'[Month Name] )
upvoted 1 times
[Removed]
1 year, 3 months ago
I think SUMMARIZE
upvoted 1 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel