Is there any way to import/export measure expressions from excel file in POWER BI?
Its a pain to create all the measures again in every small project.
i know its possible in Qlik sense and other Business Intelligent tools.
Yes, this is possible, although not as straight forward as a simple click Export, click Import.
Let me offer up a few options.
- Use Excelerator BI's amazing spreadsheet to extract and copy over measures.
- Use DAX Studio to copy paste from one to the other (individually)
- Use a PowerBI shared dataset. Create your data model in a blank PowerBI. Publish it. Use the published dataset as a source for all your reports/PBIXs that need to depend on a shared model.
- If they are simple, move the calculations out of your PowerBI in to upstream ETL processes or aggregations on your database.