Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

poojasingh

Storing Dax as form of Metric in separate excel file

Submitted by on ‎08-04-2021 01:54 AM

Hi Team,

 

Is there any capabilities weher we can store the dax as separate excel file and same can be imported in power bi for metrics purposes. This process will give advantage of storing centralized copy of all the dax and maintenance too will be easy. 

 

Thanks In Advance

Power BI User

 

 

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎08-04-2021 07:14 PM

Hi @poojasingh ,

As far as I know, currently you can try these ways to export dax formula from Power BI:

  1. Using DAX Studio to export, refer this viedo: Export Measures from Power BI to Excel using Dax Studio 
  2. Export to template file first and open datamodelschema file by json, refer this document: Exporting Measure and Column formulas from Power BI 

 

For importing to Power BI, you can save the original one as a template file(.pbit) and modify the template file with your new model. For more details, please refer to doc below:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-templates

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses