Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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(...),...) |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.