Syntax:
EDATE(<start_date>, <month>)
Parameters:
start_date: A date in datetime or text format that represents the start date.
month: An integer that represents the number of months before or after start_date.
Action:
Returns the date that is the indicated number of months before or after the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
Syntax:
DATEVALUE(<date_text>)
Parameters:
date_text: Text that represents a date.
Action:
Converts a date in the form of text to a date in datetime format.
Syntax:
DATEDIFF(<start_date>, <end_date>), <interval>)
Parameters:
start_date: Any DAX expression that returns a datetime value.
end_date: Any DAX expression that returns a datetime value.
interval: The interval to use when comparing dates. The value can be one of the following:
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR
Action:
Returns the count of interval boundaries crossed between two dates.
Hold the Ctrl key and press Enter
Action:
Fills the selected cell range with the current entry.
Hold the Ctrl key and press Spacebar
Action:
Selects an entire column in a worksheet.
Hold the Ctrl key and press Arrow Key
Action:
Moves to the edge of the cuttent data region in a worksheet.
Hold the Ctrl key and press 9 (eight numaric key)
Action:
Hides the selected rows.
Hold the Ctrl key and press 8 (eight numaric key)
Action:
Display or hides the outline symbols.
Hold the Ctrl key and press 6 (six numaric key)
Action:
Alternates between hiding and displaying objects.
