INFO.COLUMNS DAX Function (Information)

Syntax  |  Return values  |  Remarks  

Returns a list of all columns in the current model with columns matching the schema rowset for column objects.

Syntax

INFO.COLUMNS ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
RestrictionName	Optional Repeatable	Restriction name.
RestrictionValue	Optional Repeatable	Restriction value.

Return values

Table An entire table or a table with one or more columns.

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: Nov 14, 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.