Forum Discussion
Using Dax Studio to Get Both Measures and Colulmns with Table Names
(was not sure where else to post a Dax Studio Question... hoping it will work here)
I am new to Dax Studio, but have been reading and playing around. I would like to better document for reference all my DAX Measures and Calculated Columns, tables, etc (that I created ..... not Date or others done by Power BI).
I can do this to get a list of all Measures
select * from $SYSTEM.TMSCHEMA_MEASURES
I can do this do get calculated Columns, but it gives me other system generated ones.
select * from $SYSTEM.TMSCHEMA_COLUMNS where [Type] = 2;
I was playing around with various techniques to get table names not numbers with the columns, but not gotten that to work yet. Ideally I would have one query to get Calculated Columns and Measures, and calculated tables I might have created but not PBI. Return the name, the expression and for the table for the Columns/Measures for where they reside.
I started reviewing this site as a good resource, but still was lost.
https://exceleratorbi.com.au/getting-started-dax-studio/
Originally I figured someone else had already worked through this to grab all their DAX work out of a PBIX file, so surprised I could not find it.
Thanks
Alan
1 Reply
- v-yulgu-msft
Microsoft Employee