A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
What is the TANH function?
The TANH function is a mathematical function that calculates the hyperbolic tangent of a given number. The hyperbolic tangent is a mathematical function that describes the relationship between the sides of a right-angled triangle. In Power BI, the TANH function can be used to calculate the hyperbolic tangent of a given value, which can be useful in a wide range of scenarios.
How does the TANH function work?
The TANH function takes a single argument, which is the number that you want to calculate the hyperbolic tangent of. The function then calculates the hyperbolic tangent of that number and returns the result. The TANH function is calculated using the following formula:
TANH(x) = (EXP(x) – EXP(-x)) / (EXP(x) + EXP(-x))
Where x is the number that you want to calculate the hyperbolic tangent of.
How to use the TANH function in Power BI
Using the TANH function in Power BI is simple. Here's how you can do it:
1. Open Power BI and create a new report or open an existing report.
2. Go to the formula bar and type "=TANH(" followed by the number that you want to calculate the hyperbolic tangent of. For example, if you want to calculate the hyperbolic tangent of the number 2, you would type "=TANH(2)".
3. Press enter and the result will be displayed in the cell.
Alternatively, you can use the TANH function in a measure or calculated column. To do this, follow these steps:
1. Open Power BI and create a new report or open an existing report.
2. Go to the "Fields" pane and select the table that you want to create a measure or calculated column for.
3. Right-click on the table and select "New Measure" or "New Calculated Column", depending on which one you want to create.
4. In the formula bar, type "=TANH(" followed by the column or measure that you want to calculate the hyperbolic tangent of. For example, if you have a column called "Sales" and you want to calculate the hyperbolic tangent of the values in that column, you would type "=TANH(Sales)".
5. Press enter and the result will be displayed in the cell.
When to use the TANH function
The TANH function can be useful in a range of scenarios, including:
- Calculating growth rates: The TANH function can be used to calculate growth rates over time, which can be useful in financial and business analysis.
- Calculating trend lines: The TANH function can be used to calculate trend lines for data sets, which can help to identify patterns and trends in the data.
- Predicting values: The TANH function can be used to predict future values based on past data, which can be useful in forecasting and planning.
In this article, we've explored the TANH function in Power BI. We've looked at what the TANH function is, how it works, and how you can use it in your Power BI reports. By using the TANH function, you can perform a range of calculations and analyses that can help you make more informed decisions and gain deeper insights into your data.