Excel PowerPivot DAX Function & Features
DATEVALUE Function (DAX)
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.
Excel PowerPivot: DATEDIFF Function (DAX)
Excel PowerPivot DAX Function & Features
DATEDIFF Function (DAX)
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.
Excel Keyboard Shortcuts: Ctrl + Enter
Excel Keyboard Shortcuts Ctrl Combination
Ctrl + Enter
Hold the Ctrl key and press Enter
Action:
Fills the selected cell range with the current entry.
Excel Keyboard Shortcuts: Ctrl + Spacebar
Excel Keyboard Shortcuts Ctrl Combination
Ctrl + Spacebar
Hold the Ctrl key and press Spacebar
Action:
Selects an entire column in a worksheet.
Excel Keyboard Shortcuts: Ctrl + Arrow Key
Excel Keyboard Shortcuts Ctrl Combination
Ctrl + Arrow Key
Hold the Ctrl key and press Arrow Key
Action:
Moves to the edge of the cuttent data region in a worksheet.
Excel Keyboard Shortcuts: Ctrl + 9
Excel Keyboard Shortcuts Ctrl Combination
Ctrl + 9
Hold the Ctrl key and press 9 (eight numaric key)
Action:
Hides the selected rows.
