Power BI Certification Exam - DAX Formulas () | Questions & Answers (100% Verified)

Power BI Certification Exam - DAX Formulas () | Questions & Answers (100% Verified) Power BI Certification Exam - DAX Formulas () | Questions & Answers (100% Verified) CALENDAR - ANSWER - Syntax: 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 Return Value: Returns a table with a single column named "Date" containing a contiguous set of dates, inclusive of the start and end date Example: The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015. =CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31)) The following expression returns the date table covering the range of dates in these two tables. =CALENDAR (MINX (Sales, [Date]), MAXX (Forecast, [Date])) CALENDARAUTO - ANSWER - 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. Return Value: Returns a table with a single column named "Date" that contains a contiguous set of dates. The range is calculated automatically based on data in the model. The date range returned is dates between the beginning of the fiscal year associated with MinDate and the end of the fiscal year associated with MaxDate. 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 return all dates between March 1, 2010 and February 28, 2012. DATE - ANSWER - Syntax: DATE(<year>, <month>, <day>) Parameters: year - a number representing the year month - a number representing the month or a calculation day - a number representing the day Return Value: Returns the specified date (datetime) Example: The following formula returns the date July 8, 2009: =DATE(2009,7,8) DATEDIFF - ANSWER - Syntax: DATEDIFF(<start_date>, <end_date>, <interval>) Parameters: start_date - a scalar datetime value end_date - a scalar datetime value interval - used for comparing dates and can be SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR Return Value: Count of interval boundaries crossed between the two dates Example: Dates are as follows: :59:59 and :00:00 The following all return 1: DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), SECOND ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), MINUTE ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), HOUR ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), DAY ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), WEEK ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), MONTH ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), QUARTER ) DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), YEAR ) DATEVALUE - ANSWER - Syntax: DATEVALUE(date_text) Parameters: date_text - text that represents a date