topic Re: ATAN2 in Quick Measures Gallery

ATAN2

Greg_Deckler — Sat, 07 Mar 2020 19:38:19 GMT

DAX doesn't have an ATAN2 function so I created one.

ATAN2 = VAR __x = MAX('Table'[X]) VAR __y = MAX('Table'[Y]) VAR __atan2 = SWITCH( TRUE(), __x > 0, ATAN(__y/__x), __x < 0 && __y >= 0, ATAN(__y/__x) + PI(), __x < 0 && __y < 0, ATAN(__y/__x) - PI(), __x = 0 && __y > 0, PI()/2, __x = 0 && __y < 0, PI()/2 * (0-1), BLANK() ) RETURN __atan2

eyJrIjoiNWYyNmRlYzctY2Q1NC00NDQ0LTlkYWQtOTVhNjljMTMzN2RjIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

Re: ATAN2

klago — Thu, 23 Apr 2020 16:18:22 GMT

Thanks Greg!

Re: ATAN2

Anonymous — Tue, 22 Oct 2024 11:13:53 GMT

Greg_Deckler Hi Greg, I am trying to find wind direction on PowerBI. To do that I need arctan(V/U) and then convert it into degrees. I cannot have a negative degree so I need it to go around the entire unit circle (0-360). Do you have any sugguestions? Note: if the value of V is negative, the component is south. If V is positive, the component is north. If U is negative, the component is west. If U is positive, the component is east.

Re: ATAN2

Greg_Deckler — Tue, 22 Oct 2024 13:31:18 GMT

Anonymous OK, so ATAN2 should work for you if you plug V in for y and U in for x I believe.