Which type of calculation and which formula should you use?

HOTSPOT

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table.

Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Box 1: A DAX Calculated measure

Box 2: Date.EndofQuarter(#date([Year],[Mont],1))

ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates.

The following sample formula creates a measure that returns the end of the quarter, for the current context.

= ENDOFQUARTER(DateTime[DateKey])

Reference: https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

Latest PL-300 Dumps Valid Version with 131 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments