Forum Discussion

asjones's avatar
asjones
Icon for Helper V rankHelper V
8 years ago

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's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi asjones,

     

    I would suggest you post this thread on a more related forum to get DAX studio support.

     

    Regards,

    Yuliana Gu