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
dried poppy pods Farms commented
Marijuana is simply the valuable part of the Cannabis sativa or Cannabis indica plant including the dried leaves, flower, seed, and stem. It is referred to as one of the world most valuable plant and yet the most misunderstood plant. There are so many myths surrounding its use for recreational, spiritual, and medical purposes. For this reason, marijuana use and sale are largely illegal in many countries of the world, the United State included. There are also so many facts attesting to the health benefits of cannabis many of which are being ignored. Some of these facts include marijuana acting as a neuroprotective agent in the human body as well as helping to prevent cancer and many other deadly diseases.
Like in Canada, the Netherlands and some other countries, weed sale and use are legal in some states in the USA. However, cannabis laws differ in all these states. While some allow the sale and use of Cannabis for recreational and medical purposes, many other States allow the sale and use of marijuana for strictly medical purposes. The other States put a restriction on home cultivation. Nevertheless, one can now buy weed online as well as in other legal stores or dispensary. Before I go any further, I think it’s wise I give you a list of states in the US where weed for sale is available legally.
With special permission from a doctor, people under or above the age of 21 can buy weed for medical purpose in the following states in the US.
Viral Tarpara commented
The lack of centralized measure management a key gap in PBI’s ability to act as an enterprise semantic layer. Compare PBI to how Looker, Qlik, Domo, or GoodData treat this issue as a starting point. Get this right and people will be dropping their SAP BO tomorrow.
Tomislav Mališ commented
This is one of most important things to have. Clients do not understand that we can't do bulk changes or migrations of measures.
When we work on copies of powerbi and there is minor change in dax but we don't have find replace command for it. It takes too long to go to each dax and make changes.
This would be great!, I would also add the possibility of manually evaluate a portion of the DAX formula for previewing the result (like we can do with F9 in excel)
This would be a huge QoL addition to the tool, I hope it will be implemented soon :).
Would love this. I'm in the same boat. PBIX file(s) with dozens and dozens of measures and it is unbelievably painstaking to make mass edits to them.
E A Misemer commented
What does "backlog" mean?
Pro Documentation commented
Thanks for the information . am glad to be part of this community .
René Glaus commented
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.
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!