Skip to main content
Microsoft Idea

Power BI

Needs Votes

User friendly measure editor

Vote (12) Share
Anabel's profile image

Anabel on 13 Jan 2017 23:15:21

Ability like Excel to a drag column or cells into the measure editor to create new formulas or a GUI that steps users through how to use DAX to create typical measures such share differences or growths etc . Allowing the business community type user to manage these simple measures.

Comments (2)
Anabel's profile image Profile Picture

DaveG on 05 Jul 2020 23:08:59

RE: User friendly measure editor

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

Anabel's profile image Profile Picture

DaveG on 05 Jul 2020 23:08:57

RE: User friendly measure editor

This what is really needed. Anyone who uses PowerBI long enough has had a project where the PBIX has 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. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. Thank you Anabel for posting this.