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.
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!!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |