TOJSON DAX Function (Text)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

Converts the records of a table into a JSON text.

Syntax

TOJSON ( <Table> [, <MaxRows>] )

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.

Return values

Scalar A single string value.

Result in JSON format.

Remarks

The sort order of the result cannot be controlled.

» 1 related function

Examples

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

Continent	By Country JSON
Asia	{ “header”: [“‘Customer'[CountryRegion]”, “[Amount]”], “rowCount”: 15, “data”: [ [“Australia”, 7638059.9358], [“Turkmenistan”, 118336.5519], [“Thailand”, 63107.118] ] }
North America	{ “header”: [“‘Customer'[CountryRegion]”, “[Amount]”], “rowCount”: 2, “data”: [ [“United States”, 10312118.2484], [“Canada”, 885208.0705] ] }
Europe	{ “header”: [“‘Customer'[CountryRegion]”, “[Amount]”], “rowCount”: 12, “data”: [ [“Germany”, 2519890.7983], [“United Kingdom”, 3621032.1587], [“France”, 1109665.4323] ] }

Related functions

Other related functions are:

• TOCSV

Last update: Apr 11, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

Microsoft documentation: https://learn.microsoft.com/dax/tojson-function-dax