A que se debe Dax function reference
Enviado por Herman Falchi Gálvez • 1 de Octubre de 2018 • Apuntes • 18.473 Palabras (74 Páginas) • 256 Visitas
Contenido
DAX Function Reference 11
Important 11
In This Section 11
Date and Time Functions (DAX) 11
CALENDAR Function (DAX) 11
Syntax 11
Return Value 11
Remarks 11
Examples 11
CALENDARAUTO Function (DAX) 11
Syntax 11
Return Value 12
Remarks 12
Example 12
DATE Function (DAX) 12
Syntax 13
Return Value 14
Remarks 14
Example: Returning a Simple Date 15
Description 15
Code 15
Example: Years before 1899 15
Description 15
Code 15
Example: Years before 1899 15
Description 15
Code 15
Example: Years after 1899 15
Description 16
Code 16
Example: Working with Months 16
Description 16
Code 16
Comment 16
Example: Working with Days 16
Description 16
Code 16
Comment 17
DATEDIFF Function (DAX) 17
Syntax 17
Return Value 17
Remarks 18
Example 18
DATEVALUE Function (DAX) 19
Syntax 19
Property Value/Return Value 19
Remarks 19
Example 19
DAY Function (DAX) 20
Syntax 20
Return Value 20
Remarks 20
Example: Getting the Day from a Date Column 21
Description 21
Code 21
Example: Getting the Day from a String Date 21
Description 21
Code 21
Example: Using a Day Value as a Condition 21
Description 21
Code 22
EDATE Function (DAX) 22
Syntax 22
Return Value 22
Remarks 22
Example 23
EOMONTH Function (DAX) 23
Syntax 23
Return Value 24
Remarks 24
Example 25
HOUR Function (DAX) 25
Syntax 25
Return Value 25
Remarks 25
Example 26
Example 26
MINUTE Function (DAX) 26
Syntax 26
Return Value 26
Remarks 27
Example 27
Example 27
MONTH Function (DAX) 27
Syntax 27
Return Value 28
Remarks 28
Example 28
Example 29
NOW Function (DAX) 29
Syntax 29
Return Value 29
Remarks 29
Example 29
SECOND Function (DAX) 30
Syntax 30
Return Value 30
Remarks 30
Example 31
Example 31
TIME Function (DAX) 31
Syntax 31
Return Value 31
Remarks 32
Example 32
Example 32
Example 33
TIMEVALUE Function (DAX) 33
Syntax 33
Return Value 33
Remarks 33
Example 34
TODAY Function (DAX) 34
Syntax 34
Return Value 34
...