Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Moves Measures from One table to another

Hi, I have around 60 measures under one table. Now, i want to Move all these measures to another table and delete previous table. How do i do that.
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Anonymous ,

 

Select your measures --> Go to modelling tab --> Under Property option on top --> Home Table --> Use drop down option in Home table to switch to different table.

 

Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

  • JasonW's avatar
    JasonW
    New Member
    3 years ago

    Brilliant! And to think, all this time I've been copying the measure DAX from the source table, creating a new measure in the target table (adding a "2" to the end of the target measure name to avoid duplication), pasting the DAX, swapping out the measures in my viz, deleting the original measure, then removing the "2". What a time saver this is. THANK YOU!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Cant do multiselect for measures

     

    • v-joesh-msft's avatar
      v-joesh-msft
      Icon for Solution Sage rankSolution Sage
      6 years ago

      Hi Anonymous ,

      I found a way to select multiple measures. Hold the Ctrl key in the Model view to select multiple measures, and then drag the selected measure directly to the Table you want.

      Best Regards,
      Community Support Team _ Joey
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • charleshale's avatar
        charleshale
        Icon for Continued Contributor rankContinued Contributor
        6 years ago

        this feature rocks.  Love it!

    • Gordonlilj's avatar
      Gordonlilj
      Icon for Solution Sage rankSolution Sage
      6 years ago

      As far as i know it's not possible to bulk move measures between tables

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      Anonymous ,

       

      No, I haven'e seen such feature.

       

      Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

  • GJAC's avatar
    GJAC
    New Member
    2 years ago

    My Power Bi does not have Proptery option under modeling. Version: 2.132.908.0 64-bit (August 2024)