This is part of a series of posts on Excel to DAX translation. The main article is here.
|
IF
|
IF
|
|
IFERROR
|
IFERROR
|
|
IFNA
|
N/A
|
|
IFS
|
IF(… && …),…,…)
|
|
IMABS
|
SQRT(POWER(IMREAL,2)+POWER(IMAGINARY,2))
|
|
IMAGINARY
|
IMAGINARY
|
|
IMARGUMENT
|
ATAN(IMAGINARY / IMREAL)
|
|
IMCONJUGATE
|
IMCONJUGATE
|
|
IMCOS
|
IMCOS
|
|
IMCOSH
|
IMSUM(
IMPRODUCT(
IMEXP(COMPLEX(...)),
COMPLEX(0.5,0)
),
IMPRODUCT(
IMEXP(
IMPRODUCT(
COMPLEX(...),
COMPLEX(-1,0)
)
),
COMPLEX(0.5,0)
)
)
|
|
IMCOT
|
IMDIV( IMCOS(…), IMSIN(…) )
|
|
IMCSC
|
IMDIV( COMPLEX(1,0), IMSIN(…) )
|
|
IMCSCH
|
IMDIV( COMPLEX(1,0), IMSINH(…) )
|
|
IMDIV
|
IMDIV
|
|
IMEXP
|
IMEXP
|
|
IMLN
|
IMLN
|
|
IMLOG10
|
IMLOG10
|
|
IMLOG2
|
IMLOG2
|
|
IMPOWER
|
IMPOWER
|
|
IMPRODUCT
|
IMPRODUCT
|
|
IMREAL
|
IMREAL
|
|
IMSEC
|
IMDIV( COMPLEX(1,0), IMCOS(…) )
|
|
IMSECH
|
IMDIV( COMPLEX(1,0), IMCOSH(…) )
|
|
IMSIN
|
IMSIN
|
|
IMSINH
|
IMSUB(
IMPRODUCT(
IMEXP(COMPLEX(...)),
COMPLEX(0.5,0)
),
IMPRODUCT(
IMEXP(
IMPRODUCT(
COMPLEX(...),
COMPLEX(-1,0)
)
),
COMPLEX(0.5,0)
)
)
|
|
IMSQRT
|
IMSQRT
|
|
IMSUB
|
IMSUB
|
|
IMSUM
|
IMSUM
|
|
IMTAN
|
IMDIV( IMSIN(…) , IMCOS(…) )
|
Be the first to comment