Store measure output in new table after refresh in new table

[bobbydoll11]

Hello - I have a data table, Table A, from which I want to store the sum of one of the columns, Column A, basically create a new table, Table B, with one column, Column B, being the sum of Column A. Table A is refreshed weekly, so I want each row of Column B to be each new sum of Column A. Table B would have another column, Column C, that would be the refresh date of Table A. How do I do this or is there a better way to go about this?

Table A			Table B
	Column A		Column B	Column C
Original	3		3	Original Date
After refresh 1 ->	2		5	Refresh 1 date
After refresh 2 ->	3		8	Refresh 2 date
After refresh 3 ->	4		12	Refresh 3 date
After refresh 4 ->	5		17	Refresh 4 date

[Anonymous]

@bobbydoll11  Did you find a solution to this?  I have a similar need.

[v-juanli-msft]

Hi @bobbydoll11

To my knowledge this is not possible. Power BI is a data exploration/visualization tool.

Historical data can't be stored automatically when refreshing.

you could disable  “Include in Report Refresh”  to keep a “history table”, more detalis please see here:

https://exceleratorbi.com.au/conditionally-refresh-queries-power-bi/

But it seems diffucult to achieve your requirements currently.

Best Regards

Maggie