Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bobbydoll11
Regular Visitor

Store measure output in new table after refresh in new table

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 BColumn C
Original3 3Original Date
After refresh 1 ->2 5Refresh 1 date
After refresh 2 ->3 8Refresh 2 date
After refresh 3 ->4 12Refresh 3 date
After refresh 4 ->5 17Refresh 4 date
2 REPLIES 2
Anonymous
Not applicable

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

v-juanli-msft
Community Support
Community Support

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors