DaveG on 09 Jan 2018 10:55:44
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
Administrator on 20 Aug 2020 01:21:25
Checking with Will Thompson and moving status to backlog
- Comments (115)
RE: Measure Management & DAX Editor
Great idea !
Until it will be implemented in Power BI desktop, I share my way to search a string in DAX columns and measures :
https://community.powerbi.com/t5/Desktop/How-to-search-a-string-in-all-DAX-formulas-of-a-Power-BI-desktop/m-p/363257#M164141
This method is not supported by Microsoft but it is very useful. You may even search in different reports and export formulas to Excel easily.
RE: Measure Management & DAX Editor
Great idea. Impressive work with design proposal as well.
RE: Measure Management & DAX Editor
Great Idea¡ Congratulations Dave¡
RE: Measure Management & DAX Editor
YES YES YES
RE: Measure Management & DAX Editor
Also, please add a feature to show "Unused Measures". That will help a lot with cleanup.
RE: Measure Management & DAX Editor
This is an extremely useful idea. Thank you for making a mockup!
RE: Measure Management & DAX Editor
Really nice Work DaveG with your mockup. This is a good example of how PBI Desktop's UI doesn't scale well with volume.
RE: Measure Management & DAX Editor
incredible!
RE: Measure Management & DAX Editor
I think this would be a great addition.
RE: Measure Management & DAX Editor
Very good idea, the process of adding and changing measures is way to tedious at the moment. I really hope this get's picked up quickly.