Forum Discussion

edgar_crz's avatar
edgar_crz
New Member
10 years ago

Record and apply measures when importing new data file

Hi,

 

I have created measures in a data file, and basically every quarter i will import a new file with the exact same format.

Do you know if i can automatically apply the measures created for the first file to this new file ?

 

Thanks

 

Tips and Tricks

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    edgar_crz

     

    No matter you create those measure within data file or in Power BI Desktop, it's not supported to directly copy or "transfer" those created measures even they are in same format.

     

    If you create those measures in Power BI Desktop, you can manually copy the expression of measure to create new one. If the measures are created in you data file, they are imported as columns, you can never use them in your new dataset.

     

    Regards,

  • wonga's avatar
    wonga
    Icon for Continued Contributor rankContinued Contributor
    10 years ago

    Couldn't you just refresh the dataset after you overwrite the original file with the new file since you say that it's in the same format, just more data (rows) added onto the original file? 

     

    Pretty sure you could preserve measures in that way...

    • edgar_crz's avatar
      edgar_crz
      New Member
      10 years ago

      hi, 

       

      to make it simple I created an intermediate file to gather my data from the different files and have a single file as database which enbale me the automaically apply the measures when updating with new data !

       

      Thanks for your answers,