|
|
#1
03-01-2012, 11:32 AM
|
|||
|
|||
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 
|
| Tags |
| sin cos acos in dax |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using IF and Vlookup functions | cpladson | Excel | 3 | 12-14-2011 11:57 PM |
 Assign functions to F1, etc.
|
ibclare | Office | 4 | 06-02-2011 03:22 PM |
|
** Using Functions
|
djreyrey | Excel Programming | 10 | 02-08-2011 04:18 PM |
| Automated Functions?? | nickypatterson | Outlook | 0 | 08-27-2009 01:50 PM |
| How to show help for addin functions? | Movses Asatryan | Excel | 0 | 03-02-2006 05:29 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode