5194
Anyone who uses PowerBI long enough has had a PBIX with 50-60 measures and it has become time consuming and tedious to mantain. In Excel you can do a quick find/replace to edit several formulas - in PowerBI you need to select each one individually. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. I've prepared a mockup for this as well as a DAX Editor. Let me know what you think.

Mockup: https://i.imgur.com/z6TBOQb.png?1
STATUS DETAILS
Under Review
Ideas Administrator

We've been leaning on the community tools like Tabular Editor, DAX Studio, BISM Normalizer, to provide high-end DAX editing capabilities. We don't have any short-term plans to add more DAX management tools to the product, but we'll be looking at ways to better integrate those tools. 

Comments

D

I defently would really appricate such a function may be with an opportunity to get an overview where These measures are used in what visual.

D

Would be handy to include setting the formatting (Data Type / Format) of each measure

D

We really need this feature. It is painstaking to have to go through each measure and column one by one, and wait for PowerBI to process changes. In addition, I have to cleanup and reverse engineer many other reports, which often look like spaghetti code, and it's very difficult to click through each. It would save me a ton of time and effort to bulk edit, and see all calc columns and measures in a single window.

I would compare the current setup like writing code, and processing changes after each semicolon, rather than when I compile and execute. I know how all of the columns and measures interact, and how to debug any issues.

Import and export for calc columns and measures would be amazing. Export to something a text editor could open as well, like csv, json, or maybe even excel.
This would allow the group of analysts I work with to easily share standardized measures.

D

I would prefer an import/export functionality for measures. Would give me much more flexibility and would enable me to transfer measures between pbix files

D

Thumbs up!

D

Please make this a priority!

D

It's a great idea. If Dax editor looked like MDX editor in SSAS I would be happy

D

'@Charkes Stirling :-(

D

This is the capability that I have been waiting for , for some time,,,, very nice work on the mockk up

D

Great Mockup! This is exactly what we need!