4988
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
Needs Votes
Ideas Administrator

Checking with Will Thompson and moving status to backlog

Comments

D

I tried this in Tabular Editor and it works just like Excel's "Find & Replace" function but would be even better if this is built in Power BI Desktop

D

Doesn’t Tabular editor do exact this?

D

Is it possible to create variables to control instances where you might have to change many different formulas?

D

Voted.
Meanwhile you may have a look at Power BI Sidetools : https://thebipower.fr/index.php/power-bi-sidetools/
It copies measures and calculated columns/tables to files and opens Visual Studio Code. At the moment it is read only but write access is in test.

D

As well as integrating it with VS Code to improve the user experience.

D

Would be so useful to be able to list which measures utilise a specific field. Further being able to list unused fields would be great. Thank you.

D

Great idea, should have already been a feature!

D

We are still hoping...

D

There is an APP named PMM (Power Mesures Manager) that dose just this
in this link you can read all bout it and download the App for free

https://powermeasuresm.wixsite.com/pm-m

D

Over a year ago I wrote this, and still there is no progress:

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.