Forum Discussion

mattfq's avatar
mattfq
Regular Visitor
9 years ago

Reuse query steps in a Excel file

Good morning!

 

I'm a new user of PowerBi in my company and monthly I have a task of produce graphs of a excel file.

My problem is:

 

I have to do, monthly, many (almost 500) steps to make some names get default values, like "CPU Load Average 15" to "CPU Load Average". Can I copy and past steps from another file?

 

Example of what I'm doing: http://prnt.sc/ef4hss

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi mattfq

     

    Are the names in columns or rows?

    Greetings Hp Pfister

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi mattfq,

     

    >>I have to do, monthly, many (almost 500) steps to make some names get default values, like "CPU Load Average 15" to "CPU Load Average". Can I copy and past steps from another file?

     

    If these file has the same struct and column, you can copy steps from advanced editor. In my opinion, I'd like to suggest you create a custom function to deal with the same process steps.

     

    Regards,

    Xiaoxin Sheng