Create multiple measure at once from text file

[fleetingImage]

Hi guys,

I've been searching the web and also the community for a way to generate multiple measures at once.  Either within Power BI desktop or by uploading a file with the predefined formulas.

I found these links, but this isn't exactly what I'm looking for:

https://community.powerbi.com/t5/Desktop/create-multiple-measures-at-once/m-p/171447?search-action-i...

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Creating-Multiple-Measures-at-once/m-p/138038...

The problem is as follows.  I have around 50 formulas that then will be multiplied 4x each so I'll end up with ~200.  As an example:

gSales = CALCULATE(SUM(data[Values]),data[Metric]="gross sales")

gSalesActual = CALCULATE([gSales],dimBudget[budgetDesc]="Actual")

gSalesPlan = CALCULATE([gSales],dimBudget[budgetDesc]="Plan")

gSalesPriorYear = CALCULATE([gSales],dimBudget[budgetDesc]="PY")

So my list of "base" metrics (like gross sales in the example) is about 50 of them.  Then I have to derive new ones (as in the example)

Doing that one by one is exhausting.  Is there a way to upload a file or a way to define them all at once in Power BI(copy/paste) ?

Thanks in advance!

[edhans · Accepted solution]

You want to install Tabular Editor and use the Scripting function. This is a link to some sample scripts on github. You can modify to suit your needs for your specific measures. There is also a 4 part YouTube series on getting started with Tabular Editor that is by the author of the app. Part 1 is here, and the rest are in the playlist.