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
Mockup looks great! I hope it gets picked up.
RE: Measure Management & DAX Editor
'+ 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.
RE: Measure Management & DAX Editor
Your Mockup is Fantastic DaveG !
Must have feature!
RE: Measure Management & DAX Editor
The mockup looks fantastic, I can't believe they haven't even started to implement this yet.
RE: Measure Management & DAX Editor
This is a critical issue that is keeping me from migrating several business critical reports from Excel to PowerBI. Having maintained this data for over 7 years, we followed the progression of PowerBI from it's early origins in PowerPivot, creating tons of custom measures with both complex relationships and DAX formulae in their Data Models.
RE: Measure Management & DAX Editor
What? W don't have advanced editor in Power BI? Oh come on...I was about to ditch Excel for Power Pivot and now I have to go back...
RE: Measure Management & DAX Editor
Best mockup I've seen!! In a fully centralized data storage, a variable/measure that depends on native fields can be dragged across to other PBIX just as natural and whether the new pbix consumes the same native fields then it can attempt the calculation.
RE: Measure Management & DAX Editor
Brilliant idea, great mockup that clearly highlights the benefits. The only thing you're missing in the DAX Editor is a "check formula" button. I also suggest that you cross-post this into the Excel Uservoice site as well, because the Excel measures interface, while better than the existing Power BI one, could also be improved in this way.
RE: Measure Management & DAX Editor
Very good idea and preparation, I like that mockup.
RE: Measure Management & DAX Editor
Would be very useful in complex PowerBI Projects! Mockup is great.