Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In my recent quest to create or catalog as many DAX equivalents for Excel functions, was able to leverage COMPLEX, IMAGINARY and IMREAL into IMEXP.
IMEXP =
VAR __Real1 = [IMREAL]
VAR __i1 = [IMAGINARY]
VAR __Real = EXP(__Real1) * COS(__i1)
VAR __i = EXP(__Real1) * SIN(__i1)
VAR __suffix = IF(MAX([suffix])="","i",MAX([suffix]))
RETURN
SWITCH(TRUE(),
__Real = 0 && __i = 1, __suffix,
__Real = 0 && __i = -1, "-" & __suffix,
__Real = 0, __i & __suffix,
__i = 0, __Real & "",
__i < 0 && __i = -1, __Real & "-" & __suffix,
__i < 0, __Real & "-" & ABS(__i) & __suffix,
__i = 1, __Real & "+" & __suffix,
__Real & "+" & __i & __suffix
)
eyJrIjoiODQ5ZTEyNjgtN2JlZi00YzgwLTg3YzQtZTRjYTI5Mjk4MTIzIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9