Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Import measures into Power BI

Hello,

 

I have about 50 measures which relate to the year 2016. Meaning, within the DAX code, the year 2016 is hard coded.

I want to duplicate all 50 measures and only change the year to 2017.

 

I exported the measures to a text file / Excel using Dax Studio and can easily change the measures there.

 

How can I import it back(!) into Power BI?

 

Thank you,

Tamir

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      The idea was to import all new measures in one go.

       

      For example, current measures are named as:

      • Headcount2016
      • Attrition 2016
      • etc....

      New measures:

      • Headcount2017
      • Attrition 2017
      • etc....

      So instead of copy/paste each individual measure, I would like to import them from the text file/Excel back into Power BI.

       

      For the time...copy/paste is what I did.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

        I am afraid that you can only manually change all the measure names from 2016 to 2017. It is not possible to import the new measure names and replace the old names automatically.

        Regards,
        Lydia