Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Measure Management & DAX Editor

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
Status: Completed
Comments
jrichards
Advocate I
I think this would be a great addition.
MattiasWoldu
New Member
Great idea. Impressive work with design proposal as well.
olivier10
New Member
Really nice Work DaveG with your mockup. This is a good example of how PBI Desktop's UI doesn't scale well with volume.
germanhenrique1
New Member
Great Idea¡ Congratulations Dave¡
benla
Regular Visitor
Also, please add a feature to show "Unused Measures". That will help a lot with cleanup.
fbcideas_migusr
New Member
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.
shapkovromanBI
Regular Visitor
incredible!
do1
New Member
For measures alone, you can actually use Tabular Editor https://tabulareditor.github.io/, although it is unsupported. Tabular Editor lets you connect to a running instance of Power BI Desktop, or to open a .pbit file. You can also export/import measure properties (such as format strings, descriptions, expressions) to a .TSV file for batch editing in Excel. See https://github.com/otykier/TabularEditor/wiki/Useful-script-snippets#export-object-properties-to-a-file for more details.
Lindaoscar87
New Member
Do you need an urgent blank ATM CARD to solve your financial needs, My name is Linda Oscar, and i just want to tell the world my experience with everyone. i discovered a hacking guy called Christopher. he is really good at what he is doing, i inquired about the BLANK ATM CARD. if it works or even Exist, than i gave it a try and asked for the card and agreed to their terms and conditions. three days later i received my card and tried it with the closest ATM machine close to me, to my greatest surprise it worked like magic. i was able to withdraw up to 6000 euro. This was unbelievable and the happiest day of my life. there is no ATM MACHINES this BLANK ATM CARD CANNOT penetrate into it because it have been programmed with various tools and software. it impossible for the CCTV to detect you i don't know why i am posting this here, i just felt this might help those of us in need of financial stability. Christopher have really change my life. if you want to contact them, HERE is the email address: (blankatmcard661@gmail.com) His website (http://blankatmcard661.wix.com/blankcard)
snouss
New Member
You could develop a graphical interface where formulas are boxes with inputs and outputs and links to data tables and other formula boxes! See software like Blender 3D (Nodes) or 3DSmax! It's so boring to learn a language for every application! When will Microsoft take the step of the 90s in terms of user interface?