Tabular Editor 2 - Setting DataType of a new measure

Aaron_C — Tue, 13 Aug 2024 14:43:25 GMT

Hi all,

When creating a new measure, I would also like to set the DataType for the measure, however when trying the below script, I receive an error telling me that "Property or indexer 'Measure.DataType' cannot be assigned to -- it is read only.

Is there a way to set data types with Tabular Editor 2??

//Creates default hex colour measures

var measureTable = Model.Tables["Calculations"]; // Gets the table object specified

var newMeasure = measureTable.AddMeasure( // Add new measure to specified measure table
"Hex Red", // Name
"#E3A711", // DAX Expression
"Conditional\\Tabular Editor Test\\" // Puts into Display Folders dynamically
);
newMeasure.FormatDax(); // Formats DAX automatically
newMeasure.IsHidden = true; // Set hidden or visible
newMeasure.DataType = DataType.String;

Thanks,
Aaron

Re: Tabular Editor 2 - Setting DataType of a new measure

Anonymous — Wed, 14 Aug 2024 05:30:58 GMT

Hi @Aaron_C ,

As far as I know, you can use the Properties view to review and edit the value of all properties of the currently selected object(s) such as the Name, Expression and Hidden properties, in the TOM Explorer.
For measures, this is where you can set the Format String, for example. For more information,

see Properties view.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Tabular Editor 2 - Setting DataType of a new measure in Developer

Tabular Editor 2 - Setting DataType of a new measure

Re: Tabular Editor 2 - Setting DataType of a new measure