Shawn Marx on 21 Jan 2021 15:07:11
The purpose of this enhancement would be to reduce the tedious process of adding the same measures across different PBI models or files connected to the live models. Some of this is addressed in the new paid version of Tabular Editor, but I believe it should be made more accessible by being a mainline PBI feature.
1) Add in the ability to create a text template for a measure where many measures can be created from it with small variations. The measure design would need to be enhanced so that color highlighting would make it obvious which portions of a measure code come from a template and which are specific to the child measure. Template changes would continue to alter the measures that use it.
2) The source of these templates can be either from within the PBI file or from an organizational source.
3) Coming from an Organizational source, a group of fully defined measures could be brought in at one time into a project.
4) Coming from a single template (within or organizational), many of measures could be created at once using a typed in or pasted table which contains how each measure should differ (name of measure, table/column change #, format option)
IMO this would combine well with the mockup concept in this Idea:
https://ideas.powerbi.com/ideas/idea/?ideaid=5a7e8481-68ee-40f9-bdb6-7f755b2be7a9