Adding Custom Columns when Creating A Dataset via the API

[rayishome]

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.  

[Eric_Zhang · Accepted solution]

---

@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.

[rayishome]

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

[Anonymous]

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.