Exam 70-779 topic 1 question 81 discussion

Actual exam question from Microsoft's 70-779

Question #: 81
Topic #: 1

HOTSPOT -
You have a date column named [Date] in the format of mm-dd-yyyy.
You need to create a column named Quarter that displays the yearly quarter. A sample of the desired data is shown in the following table.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Reference:
https://www.decisivedata.net/blog/quickly-create-week-month-quarter-and-year-fields-from-a-date-using-dax

by CABREU at Feb. 7, 2020, 6:32 p.m.

Comments

Submit Cancel

CABREU

Highly Voted 5 years, 5 months ago

smart solution

upvoted 13 times

hfgirona

4 years, 8 months ago

I'm testing every possibility of these 3: = ROUNDUP(MONTH([Date]) / 3;0) ->Return the quarter number = 1. It's oK. = ”Qtr “& ROUNDUP(MONTH([Date]) / 3;0) -> ERROR =CONCATENATE("Qtr ";ROUNDUP(MONTH([Date])/3;0)) -> Returns "Qtr 1"...->Perfect. SO doesn't works.??? =CONCATENATE("Qtr ";ROUNDUP(MONTH([Date])/3;0))

upvoted 1 times