IMPRODUCT

Greg_Deckler — Mon, 04 May 2020 16:50:47 GMT

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

IMPRODUCT = VAR __Real1 = [IMREAL1] VAR __Real2 = [IMREAL2] VAR __i1 = [IMAGINARY1] VAR __i2 = [IMAGINARY2] VAR __Real = __Real1 * __Real2 - __i1 * __i2 VAR __i = __Real1 * __i2 + __i1 * __Real2 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 )

eyJrIjoiNWM4YjNmYmMtY2E1Ny00MWIyLWFlYTYtMWVhYjJiZTkwYzcyIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

topic IMPRODUCT in Quick Measures Gallery

IMPRODUCT