Calendar() Usage: Returns a table with a single column of type Date that contains a contiguous set of dates. The date range is inclusive of Start and End Dates
Syntax : CALENDAR(<start_date>, <end_date>)Parameters
TermDefinitionstart_dateDAX expression returning a datetime value.end_dateDAX expression returning a datetime value.Calendar Dax Syntax
Return Type : Returns a table with a single column named "Date"
CALENDARAUTO() Usage : Returns a table with a single column named "Date" . The range of dates is calculated automatically based on data in the model.
Syntax : CALENDARAUTO([fiscal_year_end_month])Parameters
TermDefinitionfiscal_year_end_monthAny 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.CALENDARAUTO Syntax
Return type of Calendarauto() :Returns a table with a single column named "Date" that contains a contiguous
Comments