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 ...
firstredpepper
Advocate II
Advocate IIThank you for all those who have voted so far! If any Microsoft Teams are reading this I'd like to note that when I mention "excel-like" interface - it does not need any fancy functionality - a simple editable table like shown in the mockup would be an enormous time saver. Further functionality can be added later (like tracing dependents, formula drag-down, DAX syntax coloring, etc), but this basic editable table would be a 1000x improvement compared to clicking each measure individually. Imagine needing to create 50 measures: currently you need to press "Create new measure" and edit the formula each one at a time. With this proposed design you can create them once in PowerBI OR quickly in a table in Excel, and then simply paste them all into the existing PBIX or any other going forward. This would make collaborating between team members much easier, as well as allow you to seamlessly create standardized measure templates for all team members to use. Thanks for reading.
