Class CalculatedTable

Inheritance

object

DynamicPropertyObject

TabularObject

TabularNamedObject

Table

CalculatedTable

Implements

ICustomTypeDescriptor

INotifyPropertyChanging

IComparable

IDescriptionObject

ILineageTagObject

IExtendedPropertyObject

ITabularPerspectiveObject

IHideableObject

ITranslatableObject

IAnnotationObject

ISynonymObject

IClonableObject

ITabularObjectContainer

IDaxObject

IDaxDependantObject

ITomErrorMessageObject

IExpressionObject

ITabularNamedObject

ITabularObject

INotifyPropertyChanged

INamedObject

Inherited Members

Table.ClearAnnotations()

Table.GetAnnotation(int)

Table.HasAnnotation(string)

Table.GetAnnotation(string)

Table.SetAnnotation(int, string)

Table.GetNewAnnotationName()

Table.SetAnnotation(string, string)

Table.RemoveAnnotation(string)

Table.GetAnnotationsCount()

Table.GetAnnotations()

Table.ClearExtendedProperties()

Table.HasExtendedProperty(string)

Table.GetExtendedPropertyType(int)

Table.GetExtendedPropertyType(string)

Table.GetExtendedProperty(int)

Table.GetExtendedProperty(string)

Table.SetExtendedProperty(int, string, ExtendedPropertyType)

Table.GetNewExtendedPropertyName()

Table.SetExtendedProperty(string, string, ExtendedPropertyType)

Table.RemoveExtendedProperty(string)

Table.GetExtendedPropertyCount()

Table.GetExtendedProperties()

Table.CreateNew(Model, string)

Table.Clone(string, bool)

Table.AddMeasure(string, string, string, IInsertOptions)

Table.AddPartition(string, string)

Table.AddMPartition(string, string)

Table.AddPolicyRangePartition(string)

Table.AddEntityPartition(string, string)

Table.AddCalculatedColumn(string, string, string, IInsertOptions)

Table.AddDataColumn(string, string, string, DataType, IInsertOptions)

Table.AddHierarchy(string, string, IInsertOptions, params Column[])

Table.AddHierarchy(string, string, params string[])

Table.AddHierarchy(string, string, params Column[])

Table.AddHierarchy(string, string, IInsertOptions, params string[])

Table.GetChildren()

Table.Children_CollectionChanged(object, NotifyCollectionChangedEventArgs)

Table.AddRefreshPolicy()

Table.RemoveRefreshPolicy()

Table.CustomReinit()

Table.ApplyRefreshPolicy(DateTime)

Table.ApplyRefreshPolicy()

Table.Annotations

Table.ExtendedProperties

Table.DataCategory

Table.Description

Table.IsHidden

Table.ShowAsVariationsOnly

Table.IsPrivate

Table.AlternateSourcePrecedence

Table.ExcludeFromModelRefresh

Table.LineageTag

Table.SourceLineageTag

Table.SystemManaged

Table.ExcludeFromAutomaticAggregations

Table.InPerspective

Table.TranslatedDescriptions

Table.TranslatedNames

Table.Synonyms

Table.Parent

Table.Sets

Table.Partitions

Table.Columns

Table.Hierarchies

Table.Measures

Table.IsVisible

Table.TableGroup

Table.DependsOn

Table.ReferencedBy

Table.AllLevels

Table.UsedInRelationships

Table.DataColumns

Table.CalculatedColumns

Table.RelatedTables

Table.Source

Table.SourceType

Table.RowLevelSecurity

Table.DaxObjectName

Table.DaxObjectFullName

Table.DaxTableName

Table.ObjectLevelSecurity

Table.ErrorMessage

Table.DefaultDetailRowsExpression

Table.RefreshPolicy

Table.Mode

Table.PolicyType

Table.RollingWindowGranularity

Table.RollingWindowPeriods

Table.IncrementalGranularity

Table.IncrementalPeriods

Table.IncrementalPeriodsOffset

Table.PollingExpression

Table.SourceExpression

Table.EnableRefreshPolicy

TabularNamedObject.AllowDelete(out string)

TabularNamedObject.CanEditName()

TabularNamedObject.CanDelete()

TabularNamedObject.CanDelete(out string)

TabularNamedObject.Delete()

TabularNamedObject.CompareTo(object)

TabularNamedObject.MetadataIndex

TabularNamedObject.MetadataObject

TabularNamedObject.Name

TabularObject.SetValue(object, object, Action<object>, string)

TabularObject.SetValue<T>(T, T, Action<T>, string)

TabularObject.IsRemoved

TabularObject.Model

TabularObject.ObjectType

TabularObject.ObjectTypeName

TabularObject.PropertyChanged

TabularObject.PropertyChanging

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace

TabularEditor.TOMWrapper

Assembly

TOMWrapper.dll

public class CalculatedTable : Table, ICustomTypeDescriptor, INotifyPropertyChanging, IComparable, IDescriptionObject, ILineageTagObject, IExtendedPropertyObject, ITabularPerspectiveObject, IHideableObject, ITranslatableObject, IAnnotationObject, ISynonymObject, IClonableObject, ITabularObjectContainer, IDaxObject, IDaxDependantObject, ITomErrorMessageObject, IExpressionObject, ITabularNamedObject, ITabularObject, INotifyPropertyChanged, INamedObject

Extension Methods

ScriptHelper.Output(object)

DaxDependencyHelper.Tokenize(IDaxDependantObject)

DaxDependencyHelper.Tokenize(IDaxDependantObject, bool)

DaxDependencyHelper.Tokenize(IDaxDependantObject, ExpressionProperty)

DaxDependencyHelper.Tokenize(IDaxDependantObject, ExpressionProperty, bool)

TabularObjectContainerHelper.GetChildrenRecursive(ITabularObjectContainer, bool)

Properties

DefaultExpressionProperty

Gets the default expression property on the current object.

public override ExpressionProperty? DefaultExpressionProperty { get; }

Property Value

Type	Description
ExpressionProperty?

Expression

The Expression of this Calculated Table.

[Browsable(true)]
public string Expression { get; set; }

Property Value

Type	Description
string

Methods

AddCalculatedTableColumn(string, string, string, DataType)

Adds a new Calculated Table column to the table.

public CalculatedTableColumn AddCalculatedTableColumn(string name = null, string sourceColumn = null, string displayFolder = null, DataType dataType = DataType.Automatic)

Parameters

Type	Name	Description
string	name
string	sourceColumn
string	displayFolder
DataType	dataType

Returns

Type	Description
CalculatedTableColumn

Exceptions

PowerBIGovernanceException

CreateNew(Model, string, string)

Creates a new Calculated Table and adds it to the specified Model. Also creates the underlying metadataobject and adds it to the TOM tree.

public static CalculatedTable CreateNew(Model parent, string name = null, string expression = null)

Parameters

Type	Name	Description
Model	parent
string	name
string	expression

Returns

Type	Description
CalculatedTable

GetExpression(ExpressionProperty)

Gets the specified expression from the current object.

public override string GetExpression(ExpressionProperty expressionProperty)

Parameters

Type	Name	Description
ExpressionProperty	expressionProperty

Returns

Type	Description
string

Exceptions

InvalidEnumArgumentException

Thrown when the current object does not support the specified ExpressionProperty

GetExpressionProperties()

Gets all supported expression properties on the current object.

public override IEnumerable<ExpressionProperty> GetExpressionProperties()

Returns

Type	Description
IEnumerable<ExpressionProperty>

Init()

Derived members should override this method to instantiate child objects

protected override void Init()

OnPropertyChanged(string, object, object)

Fired after a property is changed

protected override void OnPropertyChanged(string propertyName, object oldValue, object newValue)

Parameters

Type	Name	Description
string	propertyName
object	oldValue
object	newValue

OnPropertyChanging(string, object, ref bool, ref bool)

Called before a property is changed on an object. Derived classes can control how the change is handled. Throw ArgumentException within this method, to display an error message in the UI.

protected override void OnPropertyChanging(string propertyName, object newValue, ref bool undoable, ref bool cancel)

Parameters

Type	Name	Description
string	propertyName	Name of the changed property.
object	newValue	New value assigned to the property.
bool	undoable	Return false if automatic undo of the property change is not needed.
bool	cancel	Return true if the property change should not apply.

SetExpression(ExpressionProperty, string)

Sets the specified expression on the current object.

public override void SetExpression(ExpressionProperty expressionProperty, string expression)

Parameters

Type	Name	Description
ExpressionProperty	expressionProperty
string	expression

Exceptions

InvalidEnumArgumentException

Thrown when the current object does not support the specified ExpressionProperty