Skip to main content

Power BI

Needs Votes

Measure Management & DAX Editor

Vote (4691) Share
DaveG's profile image

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)
DaveG's profile image Profile Picture

0763df50 51c7-ea11-a812-000d3a579c34 on 16 Aug 2020 04:01:45

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.

DaveG's profile image Profile Picture

f8821e51 074f-4eb8-90b1-c25db34b9465 on 16 Aug 2020 04:01:33

RE: Measure Management & DAX Editor

Great idea. Impressive work with design proposal as well.

DaveG's profile image Profile Picture

a9c38bb7 decf-49b7-a693-4826b0645c9c on 16 Aug 2020 04:01:20

RE: Measure Management & DAX Editor

Great Idea¡ Congratulations Dave¡

DaveG's profile image Profile Picture

6a4f44d8 bfdc-4ccf-b1fb-4c82e1e23490 on 16 Aug 2020 04:01:17

RE: Measure Management & DAX Editor

YES YES YES

DaveG's profile image Profile Picture

8d37a2ff 17fe-40c8-a5de-e22c4aff8502 on 16 Aug 2020 04:01:12

RE: Measure Management & DAX Editor

Also, please add a feature to show "Unused Measures". That will help a lot with cleanup.

DaveG's profile image Profile Picture

c14fed1a 17fa-493e-b7a0-8b360b025891 on 16 Aug 2020 04:01:11

RE: Measure Management & DAX Editor

This is an extremely useful idea. Thank you for making a mockup!

DaveG's profile image Profile Picture

40502e40 76ce-4f42-b63d-31ddf675aac9 on 16 Aug 2020 04:01:10

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.

DaveG's profile image Profile Picture

c288a219 b6e1-4a04-b216-221136e13688 on 16 Aug 2020 04:01:09

RE: Measure Management & DAX Editor

incredible!

DaveG's profile image Profile Picture

5660a260 a191-47f2-86d5-827058e77a88 on 16 Aug 2020 04:01:08

RE: Measure Management & DAX Editor

I think this would be a great addition.

DaveG's profile image Profile Picture

8b4ef9b0 5ae9-45b9-ae0f-3664dd22bfd3 on 16 Aug 2020 04:00:59

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.