ModelTableColumns Calculated Column Output Formula As Text

[wsnyder]

Hi all,

Working on documenting a Power Pivot Data Model.
I reviewed the Object Model Documentation for the Data Model (Model Object), I do not see a way to get the formula for a Calculated Column as a text string so I can output for my documentation?

Do you know if it is possible?

Thanks
w

 

[Matt Allington]

You can do it using DAX Studio and the inbuilt DMVs

same concept as the measures in this article

DAX Studio for Power BI: Getting Started

DAX Studio is a free tool that allows you to query your Power Pivot/Power BI data models. Learn exactly how using DAX Studio can add value ?

exceleratorbi.com.au

 

[wsnyder]

Thanks Matt,

The Power Pivot Utilities is awesome!
-w