These two measures convert Cartesian coordinates to polar coordinates. Both take two parameters, x and y, which are Cartesian coordinates.
r = SQRT(POWER(MAX([x]),2)+POWER(MAX([y]),2))
theta =
SWITCH(TRUE(),
MAX([x])>0, ATAN(MAX([y])/MAX([x])),
MAX([x])<0 && MAX([y])>=0, ATAN(MAX([y])/MAX([x]))+PI(),
MAX([x])<0 && MAX([y])<0, ATAN(MAX([y])/MAX([x]))-PI(),
MAX([x])=0 && MAX([y])>0,PI()/2,
MAX([x])=0 && MAX([y])<0,-1*PI()/2,
BLANK()
)
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
