Saved Bookmarks
| 1. |
What Do You Understand By New Calendarauto() Function In Dax(ssas)? |
|
Answer» CALENDARAUTO function 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. Example: In this example, the MinDate and MaxDate in the data model are JULY 1, 2010 and June 30, 2011. CALENDARAUTO() will return all dates between January 1, 2010 and December 31, 2011. CALENDARAUTO(3) will actually return all dates between April 1, 2010 and March 31, 2012. CALENDARAUTO function 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. Example: In this example, the MinDate and MaxDate in the data model are July 1, 2010 and June 30, 2011. CALENDARAUTO() will return all dates between January 1, 2010 and December 31, 2011. CALENDARAUTO(3) will actually return all dates between April 1, 2010 and March 31, 2012. |
|