Archive by Author

DAX Quizzes

This DAX quiz has the goal to check whether you have good confidence in DAX functions. Read the following questions carefully and find the correct answer from the options provided. There’s no su...

XNPV Function (DAX)

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(     &lt...

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(   ...

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 fa...

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 ...

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>) Ho...

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....

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 VA...

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 resultan...