I-IM Excel to DAX Translation

[Greg_Deckler]

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(...) )