BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 08 June 2017
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
How to move measures between tables
This won't change anyone's life, but it's a nice little tip I didn't know about (thanks, Sam). Suppose you've created a measure in one table, and want to move it to another:
You've created a measure called TotalSalesValue in the tblCentre table, but want to move it to the tblPurchase table.
To do this, first select the measure you want to move:
The measure we want to move.
Now choose a different home table for it on the Modeling tab of the ribbon:
Just choose which table you want the measure to belong to.
Power BI Desktop automatically redraws your field list:
The measure appears automatically in its new home.
Simple - but strangely satisfying!