Notifications
Clear all
Topic starter
16/10/2022 8:02 am
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.
Suggested 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