Syntax:
CLOSINGBALANCEMONTH(<expression>,<dates>,[<filter>])
Parameters:
expression: An expression that returns a scalar value.
dates: A column that contains dates.
filter: (optional) An expresion that specifies a filter to apply to the current context
Action:
Evaluates the expression at the lat date of the month in the current context.
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.
Syntax:
WEEKDAY(<date>, <return_type>)
Parameters:
date: A date in datetime format.
return_type: A number that determines the return value (An integer number from 1 to 7.)
Action:
Returns a number from 1 to 7 identifying the day of the week of a date. By default the day ranges from 1 (Sunday) to 7 (Saturday).
In defult PowerPivot tab is not enable.
Syntax:
CALENDARAUTO([<fiscal_year_end_month>])
Parameters:
fiscal_year_end_month: Any DAX expression that returns an integer from 1 to 12. If omitted, defaults to the value specified in the calendar table template for the current user, if present; otherwise, defaults to 12.
Action:
Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.
Syntax:
DATE(<year>, <month>, <day>)
Parameters:
year: A number representing the year.
month :month is a number from 1 to 12, then it represents a month of the year. 1 represents January, 2 represents February, and so on until 12 that represents December.
day: day is a number from 1 to the last day of the given month then it represents a day of the month.
Action:
Returns the specified date in datetime format.
Syntax:
CALENDAR(<start_date>, <end_date>)CALENDAR(<start_date>, <end_date>)
Parameters:
start_date: Any DAX expression that returns a datetime value.
end_date :Any DAX expression that returns a datetime value.
Action:
Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.
(Hold the Alt key and press Down arrow key)
Open the AutoFilter Menu Dailog Box.
