IMDIV 05-04-2020 10:07 AM

[Greg_Deckler]

In my recent quest to create or catalog as many DAX equivalents for Excel functions, was able to leverage COMPLEX, IMAGINARY and IMREAL into IMDIV.

IMDIV = 
    VAR __Real1 = [IMREAL1]
    VAR __Real2 = [IMREAL2]
    VAR __i1 = [IMAGINARY1]
    VAR __i2 = [IMAGINARY2]
    VAR __Real = DIVIDE(__Real1 * __Real2 + __i1 * __i2,POWER(__Real2,2) + POWER(__i2,2),0)
    VAR __i = DIVIDE(-1 * __Real1 * __i2 + __i1 * __Real2,POWER(__Real2,2) + POWER(__i2,2),0)
    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
    )

eyJrIjoiNzJiOTcwOTYtZjY0NS00NGMwLWFmNGYtZTdhNWVjZTRkMmMzIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9