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
Understanding the ISNONTEXT Function
The ISNONTEXT function in DAX is used to determine whether a value is not a text string. It returns the value TRUE if the expression is not a text string, and FALSE if it is a text string.
The syntax for the function is as follows:
ISNONTEXT(❰value❱)
Here, the value argument can be a column reference, a scalar value, or an expression that returns a value.
Examples of Using the ISNONTEXT Function
To illustrate the use of the ISNONTEXT function, let's consider some examples.
Example 1: Using ISNONTEXT with a Column Reference
Suppose we have a table called "Sales" with the following columns: "Product", "Quantity", and "Price". The "Quantity" column contains numerical values while the "Product" column contains text values.
We can use the ISNONTEXT function to create a new column that indicates whether the "Product" value is not a text string. To do this, we can use the following formula:
Non-Text Product = ISNONTEXT(Sales[Product])
This formula will return TRUE for all rows where the "Product" value is not a text string.
Example 2: Using ISNONTEXT with a Scalar Value
Suppose we have a measure called "Total Sales" that calculates the total sales for a given period. We want to create a new measure called "Total Sales (Text Only)" that calculates the total sales for periods where the "Period" value is a text string.
To do this, we can use the following formula:
Total Sales (Text Only) = CALCULATE([Total Sales], ISNONTEXT(‘Sales'[Period]))
This formula will calculate the total sales only for periods where the "Period" value is a text string.
In conclusion, the ISNONTEXT function in DAX is a useful tool for data analysis in Power BI. It allows users to determine whether a value is not a text string, which can be helpful in creating custom calculations and formulas. By using the examples provided above, you can start using the ISNONTEXT function in your own Power BI projects.