Forum Discussion
create multiple measures at once
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.
The new Quick Calcs have running totals in them.
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?
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.
