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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

move measures to new table

I am restructuring a report that consist of 20 tables (and measure groups) I need to create new tables and move existing measures to that new table - essentially creating a measure group with measures that relate to each other. Now I can do this by copying the measure formula, delete the old and paste as a new measure in the new table. Then I need to find all visuals where the measure was used and fix that - this can be done more efficiently. I would like to be able to move a measure from one table to another - dag between tables or click "Move" and select a new location.
Status: Needs Votes
Comments
John_Schown
New Member
You can change the home table of a measure by selecting the measure and going to the Modeling tab and change the Home Table to the appropriate table.
fbcideas_migusr
New Member
Great tip @John Schown - works a treat and solves practically all this request. Even if the charts break, you can update the formula (ie probably has old table name referenced) and the charts works again! Auto updating any old table names inside formulas is unfeasible I believe, as PowerBI can't always be sure of new one.
ponrajbtechit
New Member
This is the basic feature that every application should have. Pls add it in next release
Mohammad_AlSalm
New Member
it is already there ... https://www.wiseowl.co.uk/blog/s2537/move-measure.htm
JRule1
New Member
Yeah - you can go through the maddening process of moving each measure individually, but what is lacking here (and is the point of "efficiency" in Kristinn's suggestion) is a quick way to move multiple measures at once.
vivian_xiong
New Member
'@Mohammad AI-Salman Thank you. It works perfect!
nicolette_izqui
New Member
Hi! Changing the home table of a measure by selecting the measure and going to the Modeling tab and changing the Home Table to the appropriate table is not working for me on a live data connection. It worked when I was linked to a static Excel data source. Is there a workaround for when you are connecting to a live data source, say via azure / Sql? I made a copy of a previous, nearly identical file and am hoping to avoid having to go through and make copies of each individual measure, when the changes are so minimal, and I can just move them underneath the correct table in my fields. Any info is appreciated! **perhaps there is another reason outside of the data source for why this does not work for me, so any ideas welcome!** Thanks!
fbcideas_migusr
New Member
Status changed to: Needs Votes