DAX Math & Trigonometric - TAN function


Advertisements

Description

Returns the tangent of the given angle. DAX TAN function is new in Excel 2016.

Syntax

TAN (<number>) 

Parameters

Sr.No. Parameter & Description
1

number

The angle in radians for which you want the tangent.

Return Value

The tangent of the given angle.

Remarks

If your parameter value is in degrees, multiply it by PI ()/180 or use DAX RADIANS function to convert it to radians.

Example

= TAN (RADIANS (0)) returns 0. 
= TAN (RADIANS (60)) returns 1.73205080756888. 
dax_functions_mathematical_trigonometric.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements