TOCSV DAX Function (Text)

Syntax  |  Return values  |  Examples  |  Related  

Converts the records of a table into a CSV (comma-separated values) text.

Syntax

TOCSV ( <Table> [, <MaxRows>] [, <Delimiter>] [, <IncludeHeaders>] )

Parameter	Attributes	Description
Table		The table to be converted.
MaxRows	Optional	The maximum number of rows to be converted. A negative number means all rows are converted. Default is 10.
Delimiter	Optional	The field separator. Must be a non-empty constant string. Default is ‘,’.
IncludeHeaders	Optional	If true, the header row is included. Default is true.

Return values

Scalar A single string value.

Result in CSV format.

» 1 related function

Examples

DEFINE MEASURE Sales[ByCountry] =
	VAR SalesByCustomer = 
	    ADDCOLUMNS ( 
			VALUES ( Customer[CountryRegion] ), 
			"Amount", [Sales Amount] 
		)
	VAR Result = TOCSV (  SalesByCustomer, 3, ",", FALSE  )
	RETURN Result
EVALUATE
SUMMARIZECOLUMNS ( 'Customer'[Continent], "By Country CSV", [ByCountry] )

Continent	By Country CSV
Asia	Australia,7638059.93580003 Turkmenistan,118336.552 Thailand,63107.118
North America	United States,10312118.2484997 Canada,885208.0705
Europe	Germany,2519890.79830002 United Kingdom,3621032.15870003 France,1109665.43230001

Related functions

Other related functions are:

• TOJSON

Last update: Mar 6, 2023   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.