This is part of a series of posts on Excel to DAX translation. The main article is here.
DATE |
|
DATEDIFF |
|
DATEVALUE |
|
AVERAGEX(FILTER(…)…) or CALCULATE(AVERAGE(…),…) |
|
DAY |
|
|
DATEDIFF(…,…,DAY) or ([Date1] – [Date2]) * 1. |
DB or DB |
|
|
N/A |
COUNTX(FILTER(…)…) or CALCULATE(COUNT(…),…) |
|
COUNTAX(FILTER(…)…) or CALCULATE(COUNTA(…),…) |
|
DDB or DDB |
|
DEGREES |
|
LOOKUPVALUE or MAXX(FILTER(…)…) |
|
DISC or DISC |
|
MAXX(FILTER(…)…) or CALCULATE(MAX(…),…) |
|
MINX(FILTER(…)…) or CALCULATE(MIN(…),…) |
|
FORMAT(…,”$#,##0.00″) or FORMAT(…,”Currency”) |
|
DOLLARDE
|
|
DOLLARFR
|
|
PRODUCTX(FILTER(…)…) or CALCULATE(PRODUCT(…),…) |
|
STDEVX.S(FILTER(…)…) or CALCULATE(STDEV.S(…),…) |
|
STDEVX.P(FILTER(…)…) or CALCULATE(STDEV.P(…),…) |
|
SUMX(FILTER(…)…) or CALCULATE(SUM(…),…) |
|
DURATION or Macaulay Duration Quick Measure |
|
VARX.S(FILTER(…)…) or CALCULATE(VAR.S(…),…) |
|
VARX.P(FILTER(…)…) or CALCULATE(VAR.P(…),…) |
Be the first to comment