Data Analysis Expressions (DAX)

https://learn.microsoft.com/en-us/dax
Admin
Data Analysis Expressions (DAX) is a library of functions and operators used to build formulas and...
Tokens:269,087
Snippets:3,462
Trust Score:10
Update:1 month ago
Show doc for...
Tokens:
Raw
### COUPDAYBS Example Query

Source: https://learn.microsoft.com/en-us/dax/coupdaybs-function-dax

A DAX query demonstrating the calculation of days from the start of a coupon period to the settlement date.

```DAX
EVALUATE
{
  COUPDAYBS(DATE(2011,1,25), DATE(2011,11,15), 2, 1)
}
```

--------------------------------

### UTCNOW Example

Source: https://learn.microsoft.com/en-us/dax/utcnow-function-dax

Example demonstrating how to evaluate and format the current UTC date and time.

```DAX
EVALUATE { FORMAT(UTCNOW(), "General Date") }
```

--------------------------------

### UTCTODAY Example

Source: https://learn.microsoft.com/en-us/dax/utctoday-function-dax

Example demonstrating the use of UTCTODAY formatted as a general date.

```DAX
EVALUATE { FORMAT(UTCTODAY(), "General Date") }
```

--------------------------------

### QUOTIENT Examples

Source: https://learn.microsoft.com/en-us/dax/quotient-function-dax

Examples demonstrating the use of the QUOTIENT function with literal values and expressions.

```DAX
= QUOTIENT(5,2)
```

```DAX
= QUOTIENT(10/2,2)
```

--------------------------------

### MID Examples

Source: https://learn.microsoft.com/en-us/dax/mid-function-dax

Examples demonstrating how to extract substrings from literal strings and table columns.

```DAX
MID("abcde",2,3))
```

```DAX
MID('Reseller'[ResellerName],1,5))
```

--------------------------------

### COUNT Example

Source: https://learn.microsoft.com/en-us/dax/count-function-dax

Example demonstrating how to count the number of values in the ShipDate column.

```DAX
= COUNT([ShipDate])
```

--------------------------------

### GENERATEALL Example

Source: https://learn.microsoft.com/en-us/dax/generateall-function-dax

Example demonstrating the creation of a summary table of sales by Region and Product Category.

```DAX
GENERATEALL(
SUMMARIZE(SalesTerritory, SalesTerritory[SalesTerritoryGroup])
,SUMMARIZE(ProductCategory
, [ProductCategoryName]
, "Reseller Sales", SUMX(RELATEDTABLE(ResellerSales_USD), ResellerSales_USD[SalesAmount_USD])
)
)
```

--------------------------------

### GENERATE Example

Source: https://learn.microsoft.com/en-us/dax/generate-function-dax

Example demonstrating the creation of a summary table of sales by Region and Product Category.

```DAX
GENERATE(
SUMMARIZE(SalesTerritory, SalesTerritory[SalesTerritoryGroup])
,SUMMARIZE(ProductCategory 
, [ProductCategoryName]
, "Reseller Sales", SUMX(RELATEDTABLE(ResellerSales_USD), ResellerSales_USD[SalesAmount_USD])
)
)
```

--------------------------------

### RADIANS function example

Source: https://learn.microsoft.com/en-us/dax/radians-function-dax

Example showing the conversion of 270 degrees to radians.

```DAX
= RADIANS(270)
```

--------------------------------

### SIN Function Examples

Source: https://learn.microsoft.com/en-us/dax/sin-function-dax

Examples demonstrating the use of SIN with radians and degree conversions.

```DAX
= SIN(PI())
```

```DAX
= SIN(PI()/2)
```

```DAX
= SIN(30*PI()/180)
```

```DAX
= SIN(RADIANS(30))
```

--------------------------------

### Filter Sales Order Results with START AT

Source: https://learn.microsoft.com/en-us/dax/dax-queries

Example demonstrating how to filter a Sales Order table to begin at a specific order ID.

```DAX
EVALUATE
	'Sales Order'
	ORDER BY 'Sales Order'[Sales Order] ASC
	// Start at this order, orders before this order will not be displayed
	START AT "SO43661"
```

--------------------------------

### T.DIST.RT Example

Source: https://learn.microsoft.com/en-us/dax/t-dist-rt-function-dax

An example demonstrating the usage of T.DIST.RT with specific numeric inputs.

```DAX
EVALUATE { T.DIST.RT(1.959999998, 60) }
```

--------------------------------

### ASIN Examples

Source: https://learn.microsoft.com/en-us/dax/asin-function-dax

Examples demonstrating the use of ASIN to calculate arcsine in radians and degrees.

```DAX
= ASIN(-0.5)
```

```DAX
= ASIN(-0.5)*180/PI()
```

```DAX
= DEGREES(ASIN(-0.5))
```

--------------------------------

### BITLSHIFT Basic Examples

Source: https://learn.microsoft.com/en-us/dax/bitlshift-function-dax

Examples demonstrating simple bitwise left and right shifts using constant values.

```DAX
EVALUATE 
    { BITLSHIFT(2, 3) }
```

```DAX
EVALUATE 
    { BITLSHIFT(128, -1) }
```

--------------------------------

### LOG Function Examples

Source: https://learn.microsoft.com/en-us/dax/log-function-dax

Examples demonstrating how to calculate logarithms with explicit bases, default bases, and the LOG10 equivalent.

```DAX
= LOG(100,10)
= LOG(100)
= LOG10(100)
```

--------------------------------

### DEGREES function example

Source: https://learn.microsoft.com/en-us/dax/degrees-function-dax

Example demonstrating the conversion of PI radians to degrees.

```DAX
= DEGREES(PI())
```

--------------------------------

### COMBIN Example

Source: https://learn.microsoft.com/en-us/dax/combin-function-dax

Example demonstrating the calculation of possible two-person teams from 8 candidates.

```DAX
= COMBIN(8,2)
```

--------------------------------

### ATAN Examples

Source: https://learn.microsoft.com/en-us/dax/atan-function-dax

Examples showing the calculation of arctangent in radians and degrees.

```DAX
= ATAN(1)
```

```DAX
= ATAN(1)*180/PI()
```

--------------------------------

### START AT Syntax

Source: https://learn.microsoft.com/en-us/dax/startat-statement-dax

Defines the syntax for the START AT statement, which accepts constant values or XMLA parameters.

```DAX
[START AT {<value>|<parameter>} [, …]]
```

--------------------------------

### NORM.DIST Example

Source: https://learn.microsoft.com/en-us/dax/norm-dist-function-dax

An example demonstrating the use of NORM.DIST to calculate the cumulative distribution.

```DAX
EVALUATE { NORM.DIST(42, 40, 1.5, TRUE) }
```

--------------------------------

### COSH Examples

Source: https://learn.microsoft.com/en-us/dax/cosh-function-dax

Examples demonstrating the usage of the COSH function with a constant and the EXP function.

```DAX
= COSH(4)
```

```DAX
= COSH(EXP(1))
```

--------------------------------

### Define START AT Syntax

Source: https://learn.microsoft.com/en-us/dax/dax-queries

General syntax structure for using START AT within an EVALUATE statement.

```DAX
EVALUATE <table>
[ORDER BY {<expression> [{ASC | DESC}]}[, …]
[START AT {<value>|<parameter>} [, …]]]
```

--------------------------------

### COMBINA Examples

Source: https://learn.microsoft.com/en-us/dax/combina-function-dax

Examples showing the usage of COMBINA with different numeric inputs.

```DAX
= COMBINA(4,3)
```

```DAX
= COMBINA(10,3)
```

--------------------------------

### SQRT Example

Source: https://learn.microsoft.com/en-us/dax/sqrt-function-dax

A simple usage example calculating the square root of 25.

```DAX
= SQRT(25)
```

--------------------------------

### TANH Examples

Source: https://learn.microsoft.com/en-us/dax/tanh-function-dax

Examples demonstrating the usage of the TANH function with different input values.

```DAX
= TANH(-2)
```

```DAX
= TANH(0)
```

```DAX
= TANH(0.5)
```

--------------------------------

### SQRTPI Examples

Source: https://learn.microsoft.com/en-us/dax/sqrtpi-function-dax

Examples demonstrating the calculation of the square root of pi and the square root of 2 times pi.

```DAX
= SQRTPI(1)
```

```DAX
= SQRTPI(2)
```

--------------------------------

### POWER function example

Source: https://learn.microsoft.com/en-us/dax/power-function-dax

An example demonstrating the calculation of 5 raised to the power of 2.

```DAX
= POWER(5,2)
```

--------------------------------

### GCD Examples

Source: https://learn.microsoft.com/en-us/dax/gcd-function-dax

Common usage examples for the GCD function with various integer inputs.

```DAX
= GCD(5, 2)
```

```DAX
= GCD(24, 36)
```

```DAX
= GCD(7, 1)
```

--------------------------------

### CROSSJOIN Example

Source: https://learn.microsoft.com/en-us/dax/crossjoin-function-dax

An example demonstrating the application of CROSSJOIN to two tables, Colors and Stationery.

```DAX
CROSSJOIN( Colors, Stationery)
```

--------------------------------

### LCM Examples

Source: https://learn.microsoft.com/en-us/dax/lcm-function-dax

Examples demonstrating the calculation of the least common multiple for pairs of integers.

```DAX
= LCM(5, 2)
```

```DAX
= LCM(24, 36)
```

--------------------------------

### STARTOFWEEK Fiscal Calendar Example

Source: https://learn.microsoft.com/en-us/dax/startofweek-function-dax

Example usage of STARTOFWEEK with a fiscal calendar reference.

```DAX
= STARTOFWEEK(FiscalCalendar)
```

--------------------------------

### RANDBETWEEN Example

Source: https://learn.microsoft.com/en-us/dax/randbetween-function-dax

A simple usage example returning a random integer between 1 and 10.

```DAX
= RANDBETWEEN(1,10)
```

--------------------------------

### T.INV.2T Example

Source: https://learn.microsoft.com/en-us/dax/t-inv-2t-function-dax

An example demonstrating the use of T.INV.2T with specific probability and degrees of freedom values.

```DAX
EVALUATE { T.INV.2T(0.546449, 60) }
```

--------------------------------

### UNICHAR Examples

Source: https://learn.microsoft.com/en-us/dax/unichar-function-dax

Examples demonstrating the use of UNICHAR with different numeric inputs to return specific characters.

```DAX
= UNICHAR(65)
```

```DAX
= UNICHAR(32)
```

```DAX
= UNICHAR(9733)
```

--------------------------------

### SELECTCOLUMNS Example

Source: https://learn.microsoft.com/en-us/dax/selectcolumns-function-dax

An example demonstrating how to combine two columns into a single new column using SELECTCOLUMNS.

```DAX
SELECTCOLUMNS(Customer, "Country, State", [Country]&", "&[State])
```

--------------------------------

### EVEN Function Examples

Source: https://learn.microsoft.com/en-us/dax/even-function-dax

Examples demonstrating how the EVEN function rounds various numeric inputs.

```DAX
= EVEN(1.5)
```

```DAX
= EVEN(3)
```

```DAX
= EVEN(2)
```

```DAX
= EVEN(-1)
```

--------------------------------

### Example: Simple tax function in DAX

Source: https://learn.microsoft.com/en-us/dax/best-practices/dax-user-defined-functions

A practical example of a tax calculation function with an optional parameter and JSDoc documentation.

```DAX
DEFINE
    /// AddTax takes in amount and returns amount including tax
    /// @param {NUMERIC} amount - The pre-tax value to which tax will be applied
    /// @param {NUMERIC} [taxRate] - Optional tax rate to apply, default is 0.1 (10%)
    /// @returns The amount including 10% tax
    FUNCTION AddTax = 
        ( amount : NUMERIC, taxRate : NUMERIC = 0.1 ) =>
            amount * ( 1 + taxRate )

EVALUATE
{ AddTax ( 10 ) }
// Returns 11
```

--------------------------------

### Calculate Week Start Inventory Value

Source: https://learn.microsoft.com/en-us/dax/openingbalanceweek-function-dax

Example of using the function to calculate inventory value based on a fiscal calendar.

```DAX
=
OPENINGBALANCEWEEK (
    SUMX (
        ProductInventory,
        ProductInventory[UnitCost] * ProductInventory[UnitsBalance]
    ),
    FiscalCalendar
)
```

--------------------------------

### COS Function Examples

Source: https://learn.microsoft.com/en-us/dax/cos-function-dax

Examples demonstrating the use of COS with radians and degree-to-radian conversion.

```DAX
= COS(1.047)
```

```DAX
= COS(60*PI()/180)
```

```DAX
= COS(RADIANS(60))
```

--------------------------------

### FLOOR Usage Example

Source: https://learn.microsoft.com/en-us/dax/floor-function-dax

Example demonstrating how to round values in a column down to the nearest multiple of 0.1.

```DAX
= FLOOR(InternetSales[Total Product Cost],.1)
```

--------------------------------

### T.INV Example

Source: https://learn.microsoft.com/en-us/dax/t-inv-function-dax

An example demonstrating the usage of T.INV with specific probability and degree of freedom values.

```DAX
EVALUATE { T.INV(0.75, 2) }
```

--------------------------------

### TIMEVALUE Usage Example

Source: https://learn.microsoft.com/en-us/dax/timevalue-function-dax

A simple example demonstrating the conversion of a time string into a datetime value.

```DAX
= TIMEVALUE("20:45:30")
```

--------------------------------

### Calendar Based Time Intelligence Example

Source: https://learn.microsoft.com/en-us/dax/startofmonth-function-dax

A sample formula creating a table that returns tagged primary columns corresponding to the start of the month for a fiscal calendar.

```DAX
= STARTOFMONTH(FiscalCalendar)
```

--------------------------------

### ISATLEVEL Usage Examples

Source: https://learn.microsoft.com/en-us/dax/isatlevel-function-dax

Examples demonstrating how to check for column levels and how the function behaves after navigation operations like EXPAND and COLLAPSE.

```DAX
IsYearLevel = ISATLEVEL([Fiscal Year])
IsQuarterLevel = ISATLEVEL([Fiscal Quarter])
IsMonthLevel = ISATLEVEL([Month])
IsQuarterLevelAfterExpand = EXPAND(ISATLEVEL([Fiscal Quarter]), ROWS)
IsQuarterLevelAfterCollapse = COLLAPSE(ISATLEVEL([Fiscal Quarter]), ROWS)
```

--------------------------------

### UPPER function example

Source: https://learn.microsoft.com/en-us/dax/upper-function-dax

Example demonstrating the conversion of a column value to uppercase.

```DAX
= UPPER(['New Products'[Product Code])
```

--------------------------------

### Single-column table examples

Source: https://learn.microsoft.com/en-us/dax/table-constructor

Demonstrates creating a single-column table using different syntax variations.

```DAX
EVALUATE { 1, 2, 3 }
```

```DAX
EVALUATE { (1), (2), (3) }
```

--------------------------------

### T.DIST Example

Source: https://learn.microsoft.com/en-us/dax/t-dist-function-dax

An example of evaluating the T.DIST function using the EVALUATE statement.

```DAX
EVALUATE { T.DIST(60, 1, TRUE) }
```

--------------------------------

### TOPN and ORDER BY Example

Source: https://learn.microsoft.com/en-us/dax/dax-queries

Demonstrates using TOPN to limit rows and ORDER BY to sort the final result set independently.

```DAX
EVALUATE
	TOPN(
		100,
		'Sales Order',
		// The way the data is sorted before the top 100 rows are selected
		'Sales Order'[SalesOrderLineKey], ASC
	)
	// The way the data is sorted for the results
	ORDER BY
		'Sales Order'[Sales Order] ASC,
		'Sales Order'[Sales Order Line] ASC
```

--------------------------------

### CONCATENATEX example

Source: https://learn.microsoft.com/en-us/dax/concatenatex-function-dax

A practical example of concatenating first and last names from an Employees table with a comma delimiter.

```DAX
= CONCATENATEX(Employees, [FirstName] & " " & [LastName], ",")
```

--------------------------------

### BITRSHIFT Basic Examples

Source: https://learn.microsoft.com/en-us/dax/bitrshift-function-dax

Examples demonstrating right shifting a positive integer and shifting in the opposite direction using a negative shift amount.

```DAX
EVALUATE 
    { BITRSHIFT(16, 3) }
```

```DAX
EVALUATE 
    { BITRSHIFT(1024, -3) }
```

--------------------------------

### NORM.INV Example

Source: https://learn.microsoft.com/en-us/dax/norm-inv-function-dax

An example of using NORM.INV to calculate the inverse normal distribution.

```DAX
EVALUATE { NORM.INV(0.908789, 40, 1.5) }
```

--------------------------------

### COLLAPSE function usage examples

Source: https://learn.microsoft.com/en-us/dax/collapse-function-dax

Examples demonstrating how to fetch sales values at parent, grandparent, and specific hierarchy levels.

```DAX
ParentValue = COLLAPSE([SalesAmount], ROWS)
GrandParentValue = COLLAPSE([SalesAmount], ROWS, 2)
QuarterOrSelfValue = COLLAPSE([SalesAmount], [Month])
```

--------------------------------

### LOWER function example

Source: https://learn.microsoft.com/en-us/dax/lower-function-dax

Example of converting a column of product codes to lowercase.

```DAX
= LOWER('New Products'[ProductCode])
```

--------------------------------

### COTH Example

Source: https://learn.microsoft.com/en-us/dax/coth-function-dax

Example usage of the COTH function within a DAX query.

```DAX
EVALUATE { COTH(2) }
```

--------------------------------

### Calculate Investment Periods

Source: https://learn.microsoft.com/en-us/dax/pduration-function-dax

Examples demonstrating how to use PDURATION to calculate periods for annual and monthly investment growth.

```DAX
EVALUATE
{
  PDURATION(0.025, 2000, 2200)
}
```

```DAX
EVALUATE
{
  PDURATION(0.025/12, 1000, 1200)
}
```

--------------------------------

### SAMPLEAXISWITHLOCALMINMAX Usage Example

Source: https://learn.microsoft.com/en-us/dax/sampleaxiswithlocalminmax-function-dax

A query demonstrating how to sample a sales table to 10 rows based on unit price bins and sales amount values.

```DAX
EVALUATE
SAMPLEAXISWITHLOCALMINMAX(
	10,
	SELECTCOLUMNS ( Sales, "x", [Unit Price], "y", [Sales Amount] ),
    [x],
    [y],
	10
	)
```

--------------------------------

### AVERAGEA Usage Example

Source: https://learn.microsoft.com/en-us/dax/averagea-function-dax

Example of applying the AVERAGEA function to an Amount column.

```DAX
= AVERAGEA([Amount])
```

--------------------------------

### Basic INFO.DEPENDENCIES Query

Source: https://learn.microsoft.com/en-us/dax/info-dependencies-function-dax

A simple query to retrieve all dependency information from the semantic model.

```DAX
EVALUATE
	INFO.DEPENDENCIES()
```

--------------------------------

### YIELDDISC Example Query

Source: https://learn.microsoft.com/en-us/dax/yielddisc-function-dax

Example usage of the YIELDDISC function within an EVALUATE statement.

```DAX
EVALUATE
{
  YIELDDISC(DATE(2008,2,16), DATE(2008,3,1), 99.795, 100, 2)
}
```

--------------------------------

### VAR.P Measure Example

Source: https://learn.microsoft.com/en-us/dax/var-p-function-dax

Example of a measure calculating the population variance for the SalesAmount_USD column.

```DAX
= VAR.P(InternetSales_USD[SalesAmount_USD])
```

--------------------------------

### INFO.STORAGEFOLDERS Query Example

Source: https://learn.microsoft.com/en-us/dax/info-storagefolders-function-dax

A basic DAX query to retrieve all storage folder information.

```DAX
EVALUATE
	INFO.STORAGEFOLDERS()
```

--------------------------------

### Example Query for INFO.FORMATSTRINGDEFINITIONS

Source: https://learn.microsoft.com/en-us/dax/info-formatstringdefinitions-function-dax

A basic DAX query to retrieve all format string definitions from the model.

```DAX
EVALUATE
	INFO.FORMATSTRINGDEFINITIONS()
```

--------------------------------

### TAN function examples

Source: https://learn.microsoft.com/en-us/dax/tan-function-dax

Examples showing the usage of TAN with radians and degree conversion.

```DAX
= TAN(0.785)
```

```DAX
= TAN(45*PI()/180)
```

```DAX
= TAN(RADIANS(45))
```

--------------------------------

### STDEV.P Measure Example

Source: https://learn.microsoft.com/en-us/dax/stdev-p-function-dax

Example of a measure calculating the standard deviation of the SalesAmount_USD column.

```DAX
= STDEV.P(InternetSales_USD[SalesAmount_USD])
```

--------------------------------

### STDEV.S Measure Example

Source: https://learn.microsoft.com/en-us/dax/stdev-s-function-dax

Example of a measure calculating the standard deviation of the SalesAmount_USD column.

```DAX
= STDEV.S(InternetSales_USD[SalesAmount_USD])
```

--------------------------------

### SAMPLE Function Syntax

Source: https://learn.microsoft.com/en-us/dax/sample-function-dax

The syntax for the SAMPLE function, including parameters for row count, source table, and optional ordering expressions.

```DAX
SAMPLE(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
```

--------------------------------

### SINH Example

Source: https://learn.microsoft.com/en-us/dax/sinh-function-dax

Example calculation using the SINH function to determine a probability result.

```DAX
= 2.868*SINH(0.0342*1.03)
```

--------------------------------

### AMORLINC Example Query

Source: https://learn.microsoft.com/en-us/dax/amorlinc-function-dax

A DAX query demonstrating the calculation of depreciation for the first period using specific asset parameters.

```DAX
EVALUATE
{
  AMORLINC(2400, DATE(2008,8,19), DATE(2008,12,31), 300, 1, 0.15, 1)
}
```

--------------------------------

### ISBLANK Example

Source: https://learn.microsoft.com/en-us/dax/isblank-function-dax

A practical example using ISBLANK within an IF function to prevent division by zero errors when calculating sales ratios.

```DAX
//Sales to Previous Year Ratio

= IF( ISBLANK('CalculatedMeasures'[PreviousYearTotalSales])
   , BLANK()
   , ( 'CalculatedMeasures'[Total Sales]-'CalculatedMeasures'[PreviousYearTotalSales] )
      /'CalculatedMeasures'[PreviousYearTotalSales])
```

--------------------------------

### Compare LOOKUPWITHTOTALS and LOOKUP

Source: https://learn.microsoft.com/en-us/dax/lookupwithtotals-function-dax

Demonstrates the difference between absolute navigation with LOOKUPWITHTOTALS and context-aware navigation with LOOKUP.

```DAX
LOOKUPWITHTOTALExample1 = LOOKUPWITHTOTALS([Sales Amount], [Fiscal Year], "FY2018")

LookupExample1 = LOOKUP([Sales Amount], [Fiscal Year], "FY2018")
```

--------------------------------

### Basic INFO.PARTITIONS query

Source: https://learn.microsoft.com/en-us/dax/info-partitions-function-dax

A simple query to retrieve all partition metadata from the model.

```DAX
EVALUATE
	INFO.PARTITIONS()
```

--------------------------------

### NORM.S.INV Example

Source: https://learn.microsoft.com/en-us/dax/norm-s-inv-function-dax

An example demonstrating the use of NORM.S.INV to calculate the inverse of a specific probability.

```DAX
EVALUATE { NORM.S.INV(0.908789) }
```

--------------------------------

### NOMINAL Function Example

Source: https://learn.microsoft.com/en-us/dax/nominal-function-dax

Example usage of the NOMINAL function within a DAX query.

```DAX
EVALUATE
{
  NOMINAL(0.053543, 4)
}
```

--------------------------------

### COUPPCD Example

Source: https://learn.microsoft.com/en-us/dax/couppcd-function-dax

A DAX query demonstrating the use of COUPPCD with specific settlement, maturity, frequency, and basis parameters.

```DAX
EVALUATE
{
  COUPPCD(DATE(2011,1,25), DATE(2011,11,15), 2, 1)
}
```

--------------------------------

### MOD Function Examples

Source: https://learn.microsoft.com/en-us/dax/mod-function-dax

Examples demonstrating the MOD function with positive and negative divisors.

```DAX
= MOD(3,2)
```

```DAX
= MOD(-3,-2)
```

--------------------------------

### Joining INFO.COLUMNPARTITIONSTORAGES with Model Metadata

Source: https://learn.microsoft.com/en-us/dax/info-columnpartitionstorages-function-dax

Demonstrates how to join partition storage data with column, storage, and table metadata using NATURALLEFTOUTERJOIN.

```DAX
EVALUATE
	VAR _ColumnPartitionStorages =
		INFO.COLUMNPARTITIONSTORAGES()

	VAR _ColumnStorages = 
		SELECTCOLUMNS(
			INFO.COLUMNSTORAGES(),
			"ColumnStorageID", [ID],
			"ColumnID", [ColumnID],
			"Storage Name", [Name]
		)

	VAR _Columns = 
		SELECTCOLUMNS(
			INFO.COLUMNS(),
			"ColumnID", [ID],
			"Column Name", [ExplicitName],
			"TableID", [TableID]
		)

	VAR _Tables = 
		SELECTCOLUMNS(
			INFO.TABLES(),
			"TableID", [ID],
			"Table Name", [Name]
		)

	VAR _CombinedWithColumnStorages =
		NATURALLEFTOUTERJOIN(
			_ColumnPartitionStorages,
			_ColumnStorages
		)

	VAR _CombinedWithColumns =
		NATURALLEFTOUTERJOIN(
			_CombinedWithColumnStorages,
			_Columns
		)

	VAR _CombinedWithTables =
		NATURALLEFTOUTERJOIN(
			_CombinedWithColumns,
			_Tables
		)

	RETURN
		SELECTCOLUMNS(
			_CombinedWithTables,
			"Table Name", [Table Name],
			"Column Name", [Column Name],
			"Storage Name", [Storage Name],
			"Data Version", [DataVersion],
			"State", [State]
		)
	ORDER BY [Table Name], [Column Name]
```

--------------------------------

### BITXOR Example

Source: https://learn.microsoft.com/en-us/dax/bitxor-function-dax

A DAX query demonstrating the bitwise XOR operation on the numbers 9 and 10.

```DAX
EVALUATE { BITXOR(9, 10) }
```

--------------------------------

### Basic DAX Formula Examples

Source: https://learn.microsoft.com/en-us/dax/dax-syntax-reference

Examples of valid DAX formulas ranging from simple constants to column references and function calls.

```DAX
= 3
```

```DAX
= "Sales"
```

```DAX
= 'Sales'[Amount]
```

```DAX
= (0.03 *[Amount])
```

```DAX
=0.03 * [Amount]
```

```DAX
= PI()
```

--------------------------------

### EXPAND Syntax Examples

Source: https://learn.microsoft.com/en-us/dax/expand-function-dax

Syntax variations for performing navigation and calculation, or navigation only, using axes or columns.

```DAX
EXPAND ( <expression>, <axis>[, N] )
EXPAND ( <expression>, <column>[, <column>] ... )
```

```DAX
EXPAND ( <axis>[, N] )
EXPAND ( <column>[, <column>] ... )
```

--------------------------------

### ENDOFWEEK Fiscal Calendar Example

Source: https://learn.microsoft.com/en-us/dax/endofweek-function-dax

Example usage of ENDOFWEEK with a fiscal calendar reference.

```DAX
= ENDOFWEEK(FiscalCalendar)
```

--------------------------------

### DISTINCT function example

Source: https://learn.microsoft.com/en-us/dax/distinct-table-function-dax

An example demonstrating the removal of duplicate rows from a table constructor.

```DAX
EVALUATE DISTINCT( { (1, "A"), (2, "B"), (1, "A") } )
```

--------------------------------

### CONVERT function example

Source: https://learn.microsoft.com/en-us/dax/convert-function-dax

Example of converting a date to an integer using a DAX query.

```DAX
EVALUATE
{ CONVERT ( DATE ( 1900, 1, 1 ), INTEGER ) }
```

--------------------------------

### ISINTEGER Behavior Example

Source: https://learn.microsoft.com/en-us/dax/isinteger-function-dax

Demonstrates how ISINTEGER evaluates different data types and values.

```DAX
EVALUATE
{
    IF ( ISINTEGER ( 4.2 ), "Is integer", "Is not integer" ), // RETURNS: Is not integer
    IF ( ISINTEGER ( 3.1E-1 ), "Is integer", "Is not integer" ), // RETURNS: Is not integer
    IF ( ISINTEGER ( "42" ), "Is integer", "Is not integer" ), // RETURNS: Is not integer
    IF ( ISINTEGER ( 42 ), "Is integer", "Is not integer" ) // RETURNS: Is integer
}
```

--------------------------------

### COT function example

Source: https://learn.microsoft.com/en-us/dax/cot-function-dax

An example of using the COT function within a DAX query.

```DAX
EVALUATE { COT(30) }
```

--------------------------------

### INFO.STORAGEFILES with joins

Source: https://learn.microsoft.com/en-us/dax/info-storagefiles-function-dax

Joins storage file metadata with storage folder information to provide a combined view of file locations.

```DAX
EVALUATE
VAR _StorageFiles = 
    SELECTCOLUMNS(
        INFO.STORAGEFILES(),
        "OwnerID", [OwnerID],
        "Owner Type", [OwnerType],
        "StorageFolderID", [StorageFolderID],
        "File Name", [FileName]
    )

VAR _StorageFolders = 
    SELECTCOLUMNS(
        INFO.STORAGEFOLDERS(),
        "StorageFolderID", [ID],
        "Folder Name", [Name]
    )

VAR _CombinedTable = 
    NATURALLEFTOUTERJOIN(
        _StorageFiles,
        _StorageFolders
    )

RETURN
    SELECTCOLUMNS(
        _CombinedTable,
        "Folder Name", [Folder Name],
        "File Name", [File Name],
        "Owner Type", [Owner Type],
        "Owner ID", [OwnerID]
    )
ORDER BY [Folder Name], [File Name]
```

--------------------------------

### Syntax for INFO.PARTITIONS

Source: https://learn.microsoft.com/en-us/dax/info-partitions-function-dax

The basic syntax for calling the INFO.PARTITIONS function with optional restriction parameters.

```DAX
INFO.PARTITIONS ( [<Restriction name>, <Restriction value>], ... )
```

--------------------------------

### ATANH Examples

Source: https://learn.microsoft.com/en-us/dax/atanh-function-dax

Examples demonstrating the calculation of the inverse hyperbolic tangent for specific values.

```DAX
= ATANH(0.76159416)
```

```DAX
= ATANH(-0.1)
```

--------------------------------

### ACOSH Examples

Source: https://learn.microsoft.com/en-us/dax/acosh-function-dax

Examples demonstrating the calculation of the inverse hyperbolic cosine for specific values.

```DAX
= ACOSH(1)
```

```DAX
= ACOSH(10)
```

--------------------------------

### Basic INFO.PARTITIONSTORAGES usage

Source: https://learn.microsoft.com/en-us/dax/info-partitionstorages-function-dax

Retrieves all partition storage metadata from the semantic model.

```DAX
EVALUATE
	INFO.PARTITIONSTORAGES()
```

--------------------------------

### ADDCOLUMNS Example

Source: https://learn.microsoft.com/en-us/dax/addcolumns-function-dax

Extends the ProductCategory table by calculating total sales from both the internet and reseller channels.

```DAX
ADDCOLUMNS(ProductCategory
               , "Internet Sales", SUMX(RELATEDTABLE(InternetSales_USD), InternetSales_USD[SalesAmount_USD])
               , "Reseller Sales", SUMX(RELATEDTABLE(ResellerSales_USD), ResellerSales_USD[SalesAmount_USD]))
```

--------------------------------

### ACOS function examples

Source: https://learn.microsoft.com/en-us/dax/acos-function-dax

Examples showing the calculation of arccosine in radians and conversion to degrees.

```DAX
= ACOS(-0.5)
```

```DAX
= ACOS(-0.5)*180/PI()
```

--------------------------------

### TRIM Usage Example

Source: https://learn.microsoft.com/en-us/dax/trim-function-dax

Example of using TRIM to remove trailing white space from a string.

```DAX
= TRIM("A column with trailing spaces.   ")
```

--------------------------------

### Virtual Table with Visual Shape Example

Source: https://learn.microsoft.com/en-us/dax/virtual-table-statement-dax

An example demonstrating the definition of a virtual table using SUMMARIZECOLUMNS and a visual shape with densification.

```DAX
DEFINE TABLE data = SUMMARIZECOLUMNS(ROLLUPADDISSUBTOTAL(T[Year], "IsYearTotal"), ROLLUPADDISSUBTOTAL(T[Product], "IsProductTotal"), "Meausre", SUM(T[SalesAmount]))
  WITH VISUAL SHAPE
    AXIS ROWS GROUP [Year] TOTAL [IsYearTotal] ORDER BY [Year]
    AXIS COLUMNS GROUP [Product] TOTAL [IsProductTotal] ORDER BY [Product]
    DENSIFY "IsDensified"
EVALUATE data
```

--------------------------------

### TIME Function 3:00 AM Examples

Source: https://learn.microsoft.com/en-us/dax/time-function-dax

Examples demonstrating how the TIME function handles hour overflow.

```DAX
= TIME(27,0,0)
```

```DAX
= TIME(3,0,0)
```
Tokens:
Raw