How does the XNPV function (DAX) work? The XNPV function (DAX) returns the present value for a schedule of cash flows that is not necessarily periodic. XNPV Formula Syntax XNPV( <table>...

# Category Archives : DAX Function Guide RSS feed for this section

## XIRR Function (DAX)

How does the XIRR function (DAX) work? The XIRR function (DAX) returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. XIRR Formula Syntax XIRR( &l...

## WEEKNUM Function (DAX)

How does the WEEKNUM function (DAX) work? The WEEKNUM function (DAX) returns the week number for the given date and year according to the return_type value. The week number indicates where the week...

## WEEKDAY Function (DAX)

How does the WEEKDAY function (DAX) work? The WEEKDAY function (DAX) returns a number from 1 to 7 identifying the day of the week of a date. By default the day ranges from 1 (Sunday) to 7 (Saturday...

## VARX.S Function (DAX)

How does the VARX.S function (DAX) work? The VARX.S function (DAX) returns the variance of a sample population. VARX.S Formula Syntax VARX.S( <table>, <expression>) How do you us...

## VARX.P Function (DAX)

How does the VARX.P function (DAX) work? The VARX.P function (DAX) returns the variance of the entire population. VARX.P Formula Syntax VARX.P( <table>, <expression>) How do you ...

## VAR.S Function (DAX)

How does the VAR.S function (DAX) work? The VAR.S function (DAX) returns the variance of a sample population. VAR.S Formula Syntax VAR.S( <columnName>) How do you use the VAR.S functio...

## VAR.P Function (DAX)

How does the VAR.P function (DAX) work? The VAR.P function (DAX) returns the variance of the entire population. VAR.P Formula Syntax VAR.P( <columnName>) How do you use the VAR.P funct...

## VAR Function (DAX)

How does the VAR function (DAX) work? The VAR function (DAX) stores the result of an expression as a named variable, which can then be passed as an argument to other measure expressions. Once resul...

## VALUES Function (DAX)

How does the VALUES function (DAX) work? The VALUES function (DAX) returns a one-column table that contains the distinct values from the specified table or column. In other words, duplicate values ...