Thread: Acos, Cos and Sin functions in DAX PowerPivot
View Single Post
 
Old 03-01-2012, 11:32 AM
eramzan eramzan is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Mar 2012
Posts: 1
eramzan is on a distinguished road
Default Acos, Cos and Sin functions in DAX PowerPivot
Hi,

I am relatively new to DAX. I did not find any Sin, Cos or Acos functions in DAX.

I need to convert this Excel formula to DAX in PowerPivot.

=SUM(IF(ACOS(COS(RADIANS(90-$R3))*COS(RADIANS(90-[Latitude]))+SIN(RADIANS(90-$R3))*SIN(RADIANS(90-[Latitude]))*COS(RADIANS($S3-[Longitude])))*3958.756<$AG$1,1,0))-1

Please help.

Regards:
Muhammad Ehsan
Reply With Quote