Forum Discussion
Dax Studio for Documentation
- 1 year ago
launch the following query in DAX studio after setting the output to a static Excel file that will be saved wherever you want at the end of the query execution:
SELECT DISTINCT([OBJECT_TYPE]), [OBJECT], [EXPRESSION]
from
$SYSTEM.DISCOVER_CALC_DEPENDENCY
WHERE
[OBJECT_TYPE]='CALC_COLUMN' OR [OBJECT_TYPE]='MEASURE' OR [OBJECT_TYPE]='CALC_TABLE'
Once the query is launched, DAX studio allows you to export the result to an Excel fileBy the way you can also use Info DAX functions in Power BI Desktop as an alternative
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
launch the following query in DAX studio after setting the output to a static Excel file that will be saved wherever you want at the end of the query execution:
SELECT DISTINCT([OBJECT_TYPE]), [OBJECT], [EXPRESSION]
from
$SYSTEM.DISCOVER_CALC_DEPENDENCY
WHERE
[OBJECT_TYPE]='CALC_COLUMN' OR [OBJECT_TYPE]='MEASURE' OR [OBJECT_TYPE]='CALC_TABLE'
Once the query is launched, DAX studio allows you to export the result to an Excel file
By the way you can also use Info DAX functions in Power BI Desktop as an alternative
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI