Copy Paste Data from Measure onto another Table

[LucasPilotti]

Hello,

My problem is the following:

I have created a calculated measure representing the percentage of each variable (let's say, each salesman's share in the total of sales). This measure is updated through a daily refresh of the source data. The thing is, I would like to be able to store the values of each day somewhere. Is it possible to copy paste the data from the measure onto another table and keep them as values? If not, what could be the alternative(s)?

Thank you for your time.

[alex_itkin]

Please review https://www.microsoft.com/store/apps/9N60JMZCMCHC

[v-danhe-msft]

Hi @LucasPilotti ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @LucasPilotti ,

Sorry, I am afraid you could achieve this feature due to the measure is dynamic based on your data, if any data changed, the measure will change too, you could refer to below link about how to store historical data:

https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-us...

Regards,

Daniel He