Capture changes in Azure DevOps data

[Arron]

I have a report in the Power BI desktop that shows the total estimated hours against a DevOps Epic. The report refreshes overnight and the data comes from Azure DevOps.

This data is always a snapshot- there is no table that stores the historical estimated hours. I would like to log the historical estimated hours from the report each night into a new table and then use that table to show as a burn down.

I have looked at using DAX but haven't been able to make anything work.  

Any help would be greatly appreciated.

[lbendlin · Accepted solution]

Power BI has no memory, and no concept of storage. You need to do that in the upstream system.