Table information with DAX

[MarcPomes]

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 that?

Thank you

[mahoneypat · Accepted solution]

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]

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

and fire this query : 

Select * from $SYSTEM.MDSCHEMA_MEASURES