V-Z Excel to DAX Translation

[Greg_Deckler]

This is part of a series of posts on Excel to DAX translation. The main article is here.

VALUE function	VALUE
VAR function	VAR.S or VARX.S
VAR.P function	VAR.P or VARX.P
VAR.S function	VAR.S or VARX.S
VARA function	VAR.S or VARX.S
VARP function	VAR.P or VARX.P
VARPA function	VAR.P or VARX.P
VDB function	VDB or DDB Quick Measures Gallery
VLOOKUP function	LOOKUPVALUE
WEBSERVICE function	N/A
WEEKDAY function	WEEKDAY
WEEKNUM function	WEEKNUM
WEIBULL function	WEIBULL Quick Measures Gallery
WEIBULL.DIST function	WEIBULL Quick Measures Gallery
WORKDAY function	Net Work Days Quick Measures Gallery This thread
WORKDAY.INTL function	Net Work Days Quick Measures Gallery
XIRR function	XIRR
XLOOKUP function	LOOKUPVALUE
XMATCH function	N/A
XNPV function	XNPV
XOR function	XOR Quick Measures Gallery
YEAR function	YEAR
YEARFRAC function	(([end date] - [start date]) * 1.) / [days in year] or DAYS360(...) / 360 [dasy in year] can be actual (1 in Excel), 360 (2 in Excel) or 365 (3 in Excel).
YIELD function	YIELD
YIELDDISC function	YIELDDISC
YIELDMAT function	YIELDMAT
Z.TEST function	1 - NORM.S.DIST( ( AVERAGEX('Table'[Column]) - [x] ) / (STDEV.S('Table'[Column]) / SQRT(COUNTROWS('Table') ) ),TRUE)
ZTEST function	1 - NORM.S.DIST( ( AVERAGEX('Table'[Column]) - [x] ) / (STDEV.S('Table'[Column]) / SQRT(COUNTROWS('Table') ) ),TRUE)