Measure Management & DAX Editor
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.
Checking with Will Thompson and moving status to backlog
Menno ten Have commented
Would be handy to include setting the formatting (Data Type / Format) of each measure
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.
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
Julian Payne commented
Please make this a priority!
David Cresp commented
@Charkes Stirling :-(
It's a great idea. If Dax editor looked like MDX editor in SSAS I would be happy
This is the capability that I have been waiting for , for some time,,,, very nice work on the mockk up
William McNair commented
Does moving to "Backlog" mean this feature suggestion go to the head of the line or does it get thrown into the back of the line never to be seen again. If the latter, how can we indicate that it is a very much needed feature? Is there a similar request in a different area?
Ralf Hanrieder commented
Great Mockup! This is exactly what we need!
Please Please advance this feature asap. Entire world will thank you so much. I’am sure of that.
Islam Sharaf commented
Great job on this, hopefully this gets implemented soon!
Russell Price commented
Trace Dependencies is a BIG issue that would be very helpful. It would also be awesome if the editor was available to use while in the relationship view. It is helpful to be able to see the relationships when writing the formulas.
BUY HIGH QUALITY REAL/FAKE PASSPORTS,DRIVERS LICENSE(email@example.com),ID CARDS,Counterfeits Bank notes,TOEFL,IELTS,TOEIC,SSN,divorc
mockup looks great
Mockup looks great! I hope it gets picked up.
Felix Becker commented
+ a type ahead functionality would be a plus, or kind of "auto fill", e.g. start typing "calc" than press e.g. "Tab" and the editor propose results, like "Calculate".
+ a formula checker (like others already suggested would be great.
I support entire idea. What a great effort DaveG. Thank you. Hope to see something similar soon.
Your Mockup is Fantastic DaveG !
Must have feature!
The mockup looks fantastic, I can't believe they haven't even started to implement this yet.