topic Re: Adding Custom Columns when Creating A Dataset via the API in Developer

Adding Custom Columns when Creating A Dataset via the API

rayishome — Mon, 23 Oct 2017 15:46:23 GMT

Is there a way to create a calculated column when creating a dataset.

Folliwing the API reference: https://msdn.microsoft.com/en-us/library/mt742155.aspx

It seems we can create an Expression for a Measure, but maybe not for a Column? I would like to add an If Statement on a Measure as a Custom Column. This is easily accomplished in Desktop, but not sure if the API supports this or not.

Re: Adding Custom Columns when Creating A Dataset via the API

Eric_Zhang — Tue, 24 Oct 2017 06:51:25 GMT

@rayishome wrote:

Is there a way to create a calculated column when creating a dataset.

Folliwing the API reference: https://msdn.microsoft.com/en-us/library/mt742155.aspx

It seems we can create an Expression for a Measure, but maybe not for a Column? I would like to add an If Statement on a Measure as a Custom Column. This is easily accomplished in Desktop, but not sure if the API supports this or not.

@rayishome

AFAIK, custom column is not supported. What is your scenario that a custom column is mandatory? Maybe you can just create a normal column for the dataset and implement the if statement when Adding Rows.

Re: Adding Custom Columns when Creating A Dataset via the API

rayishome — Tue, 24 Oct 2017 23:38:22 GMT

We are trying to display the last inserted record from a push dataset.

Re: Adding Custom Columns when Creating A Dataset via the API

Anonymous — Tue, 24 Jul 2018 20:12:53 GMT

One method to display the last inserted record would be to use a "Top N" filter. If you have a date/time column (or another id field) that is included in the data you would just set it up in the following manner:

Then whenever you push new data the filter will ensure only the last record gets included.