create multiple measures at once

[12scml]

Hi everyone!

I found a very handy DAX formula for creating cumulative graphs that I'm loving, however it's quite tedious entering it for every column in my table. Is there a way to make a measure template and generate it for each column simultaneously? 

Thanks!!

[Greg_Deckler]

The new Quick Calcs have running totals in them.

[12scml]

That's great! I also am making measures that simply divide the columns by a constant, would it be possible to generate a measure for each column at once? 

[Greg_Deckler · Accepted solution]

There is a Quick Measure for Division. The issue is that there is no way to do this sort of mass creation of measures in Power BI at the moment as there is no API for interacting with the Desktop. Now, a couple ways that have been thrown around to get around this. One is to create the model in Excel Power Pivot and use the Excel API's to do this and then import the model from Excel into Power BI. Another possible way would be to connect to the underlying SSAS instance for Power BI Desktop and do it that way.