Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DAX Syntax > Time Intelligence Functions > Flashcards

Time Intelligence Functions Flashcards

1
Q

OPENINGBALANCEMONTH(expression,dates[,filter])

A

Evaluates the expression at the first date of the month in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

OPENINGBALANCEQUARTER(expression,dates[,filter])

A

Evaluates the expression at the first date of the quarter, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

OPENINGBALANCEYEAR(expression,dates[,filter][,year_end_date])

A

Evaluates the expression at the first date of the year in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

CLOSINGBALANCEMONTH(expression,dates[,filter])

A

Evaluates the expression at the last date of the month in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

CLOSINGBALANCEQUARTER(expression,dates[,filter])

A

Evaluates the expression at the last date of the quarter in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

CLOSINGBALANCEYEAR(expression,dates[,filter][,year_end_date])

A

Evaluates the expression at the last date of the year in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

TOTALQTD(expression,dates[,filter])

A

Evaluates the value of the expression for the dates in the quarter to date, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

TOTALMTD(expression,dates[,filter])

A

Evaluates the value of the expression for the month to date, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

TOTALYTD(expression,dates[,filter][,year_end_date])

A

Evaluates the year-to-date value of the expression in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

NEXTDAY(dates)

A

Returns a table that contains a column of all dates from the next day, based on the first date specified in the dates column in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

NEXTMONTH(dates)

A

Returns a table that contains a column of all dates from the next month, based on the first date in the dates column in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

PREVIOUSMONTH(Dates)

A

Returns a table that contains a column of all dates from the previous month, based on the first date in the Dates column, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

PREVIOUSQUARTER(dates)

A

Returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

PREVIOUSYEAR(dates[,year_end_date])

A

Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

NEXTQUARTER(dates)

A

Returns a table that contains a column of all dates in the next quarter, based on the first date specified in the dates column, in the current context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

NEXTYEAR(dates[,year_end_date])

A

Returns a table that contains a column of all dates in the next year, based on the first date in the dates column, in the current context.

17
Q

PREVIOUSDAY(dates)

A

Returns a table that contains a column of all dates representing the day that is previous to the first date in the dates column, in the current context.

18
Q

SAMEPERIODLASTYEAR(dates)

A

Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

19
Q

DATESINPERIOD(dates, start_date, number_of_intervals, interval)

A

Returns a table that contains a column of dates that begins with a specified start date and continues for the specified number and type of date intervals.

20
Q

DATESBETWEEN(Dates, StartDate, EndDate)

A

Returns a table that contains a column of dates that begins with a specified start date and continues until a specified end date.

21
Q

PARALLELPERIOD(dates,number_of_intervals,interval)

A

Returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time.

22
Q

DATEADD(dates,number_of_intervals,interval)

A

Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.

23
Q

DATESMTD(dates)

A

Returns a table that contains a column of the dates for the month to date, in the current context.

24
Q

DATESQTD(dates)

A

Returns a table that contains a column of the dates for the quarter to date, in the current context.

25
Q

DATESYTD(dates [,year_end_date])

A

Returns a table that contains a column of the dates for the year to date, in the current context.

26
Q

FIRSTDATE(dates)

A

Returns the first date in the current context for the specified column of dates.

27
Q

STARTOFMONTH(dates)

A

Returns the first date of the month in the current context for the specified column of dates.

28
Q

STARTOFQUARTER(dates)

A

Returns the first date of the quarter in the current context for the specified column of dates.

29
Q

STARTOFYEAR(dates)

A

Returns the first date of the year in the current context for the specified column of dates.

30
Q

FIRSTNONBLANK(column,expression)

A

Returns the first value in the column, column, filtered by the current context, where the expression is not blank.

31
Q

LASTDATE(dates)

A

Returns the last date in the current context for the specified column of dates.

32
Q

ENDOFMONTH(dates)

A

Returns the last date of the month in the current context for the specified column of dates.

33
Q

ENDOFQUARTER(dates)

A

Returns the last date of the quarter in the current context for the specified column of dates.

34
Q

ENDOFYEAR(dates [,year_end_date])

A

Returns the last date of the year in the current context for the specified column of dates.

35
Q

LASTNONBLANK(column,expression)

A

Returns the last value in the column, column, filtered by the current context, where the expression is not blank.

DAX Syntax (15 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions