Forum Discussion
Querying DMV Data Types in DAX Studio
Hello CHeard192,
The $SYSTEM.TMSCHEMA_COLUMNS DMV in DAX Studio provides information about columns, including data type details, but it doesn't directly map to a dimension table for data types.
However, you can access information about data types using DAX functions:
DATATABLE: The DATATABLE function lets you create a table with explicit data types for columns.
DATATYPE: The DATATYPE function returns the data type of an expression.
ISNUMBER, ISTEXT, ISDATE: These functions return TRUE or FALSE based on whether the expression's data type matches the function's name.
VALUES: The VALUES function can be used to retrieve distinct values from a column, which can also give you an idea of the data type of that column.
COLUMNS: The COLUMNS function returns a table of columns from a table or table expression along with their data types.
Should you require further assistance, please do not hesitate to reach out to me.
Hello CHeard192,
The $SYSTEM.TMSCHEMA_COLUMNS DMV in DAX Studio provides information about columns, including data type details, but it doesn't directly map to a dimension table for data types.
However, you can access information about data types using DAX functions:
DATATABLE: The DATATABLE function lets you create a table with explicit data types for columns.
DATATYPE: The DATATYPE function returns the data type of an expression.
ISNUMBER, ISTEXT, ISDATE: These functions return TRUE or FALSE based on whether the expression's data type matches the function's name.
VALUES: The VALUES function can be used to retrieve distinct values from a column, which can also give you an idea of the data type of that column.
COLUMNS: The COLUMNS function returns a table of columns from a table or table expression along with their data types.
Should you require further assistance, please do not hesitate to reach out to me.
Huge help. Thanks Sahir!
