Quant Insights Network

admin · September 4, 2024

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

DATE	DATE
DATEDIF	DATEDIFF
DATEVALUE	DATEVALUE
DAVERAGE	AVERAGEX(FILTER(…)…) or CALCULATE(AVERAGE(…),…)
DAY	DAY
DAYS	DATEDIFF(…,…,DAY) or *([Date1] – [Date2]) 1.**
DAYS360	DAYS360
DB	DB or DB
DBCS	N/A
DCOUNT	COUNTX(FILTER(…)…) or CALCULATE(COUNT(…),…)
DCOUNTA	COUNTAX(FILTER(…)…) or CALCULATE(COUNTA(…),…)
DDB	DDB or DDB
DEC2BIN	DEC2BIN
DEC2HEX	DEC2HEX
DEC2OCT	DEC2OCT
DECIMAL	DECIMAL
DEGREES	DEGREES
DELTA	DELTA
DEVSQ	DEVSQ
DGET	LOOKUPVALUE or MAXX(FILTER(…)…)
DISC	DISC or DISC
DMAX	MAXX(FILTER(…)…) or CALCULATE(MAX(…),…)
DMIN	MINX(FILTER(…)…) or CALCULATE(MIN(…),…)
DOLLAR	FORMAT(…,”$#,##0.00″) or FORMAT(…,”Currency”)
DOLLARDE	DOLLARDE `INT([Fractional_dollar]) + ([Fractional_dollar] - INT([Fractional_dollar])) / [Fraction] * 100`
DOLLARFR	DOLLARFR `INT([Decimal_dollar]) + ([Decimal_dollar] - INT([Decimal_dollar])) * [Fraction] / 100`
DPRODUCT	PRODUCTX(FILTER(…)…) or CALCULATE(PRODUCT(…),…)
DSTDEV	STDEVX.S(FILTER(…)…) or CALCULATE(STDEV.S(…),…)
DSTDEVP	STDEVX.P(FILTER(…)…) or CALCULATE(STDEV.P(…),…)
DSUM	SUMX(FILTER(…)…) or CALCULATE(SUM(…),…)
DURATION	DURATION or Macaulay Duration Quick Measure
DVAR	VARX.S(FILTER(…)…) or CALCULATE(VAR.S(…),…)
DVARP	VARX.P(FILTER(…)…) or CALCULATE(VAR.P(…),…)

D Excel to DAX Translation