TOJSON DAX Function (Text)
Converts the records of a table into a JSON text.
Syntax
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
Result in JSON format.
Remarks
The sort order of the result cannot be controlled.
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:
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://learn.microsoft.com/dax/tojson-function-dax