INFO.COLUMNS DAX Function (Information)
Returns a list of all columns in the current model with columns matching the schema rowset for column objects.
Syntax
Parameter | Attributes | Description |
---|---|---|
RestrictionName | Optional Repeatable |
Restriction name. |
RestrictionValue | Optional Repeatable |
Restriction value. |
Return values
Field | Type |
---|---|
ID | Integer |
TableID | Integer |
ExplicitName | String |
InferredName | String |
ExplicitDataType | Integer |
InferredDataType | Integer |
DataCategory | String |
Description | String |
IsHidden | Boolean |
State | Integer |
IsUnique | Boolean |
IsKey | Boolean |
IsNullable | Boolean |
Alignment | Integer |
TableDetailPosition | Integer |
IsDefaultLabel | Boolean |
IsDefaultImage | Boolean |
SummarizeBy | Integer |
ColumnStorageID | Integer |
Type | Integer |
SourceColumn | String |
ColumnOriginID | Integer |
Expression | String |
FormatString | String |
IsAvailableInMDX | Boolean |
SortByColumnID | Integer |
AttributeHierarchyID | Integer |
ModifiedTime | DateTime |
StructureModifiedTime | DateTime |
RefreshedTime | DateTime |
SystemFlags | Integer |
KeepUniqueRows | Boolean |
DisplayOrdinal | Integer |
ErrorMessage | String |
SourceProviderType | String |
DisplayFolder | String |
EncodingHint | Integer |
RelatedColumnDetailsID | Integer |
AlternateOfID | Integer |
LineageTag | String |
SourceLineageTag | String |
Remarks
Corresponds to the TMSCHEMA_COLUMNS data management view (DMV).
As all the INFO functions, it cannot be used in calculated tables and calculated columns.
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.