Forum Discussion

MarcPomes's avatar
MarcPomes
Frequent Visitor
5 years ago
Solved

Table information with DAX

Hi all,   I would like to use the column names of other tables. For example:   Table1 Field1, Field2 value1, value2   I want to get the values Field1 and Field2.   Do you know how to do tha...
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Not sure you can do that with DAX, but you can access the column names with Table.ColumnNames in the query editor.  You can then access them with a position reference like  Table.ColumnNames(#"Changed Type"){1} to get the name of the second column (counting starts at 0).

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Not sure you can do that with DAX, but you can access the column names with Table.ColumnNames in the query editor.  You can then access them with a position reference like  Table.ColumnNames(#"Changed Type"){1} to get the name of the second column (counting starts at 0).

Regards,

Pat

kumar27's avatar
kumar27
Icon for Advocate V rankAdvocate V
5 years ago

You an use DAX stdio to get all field and table related information.

 

and fire this query : 

Select * from $SYSTEM.MDSCHEMA_MEASURES