Forum Discussion
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 that?
Thank you
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
2 Replies
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
You an use DAX stdio to get all field and table related information.
and fire this query :
Select * from $SYSTEM.MDSCHEMA_MEASURES
