Aggregate Daily Refresh Data/Measures

[beanandrew18]

Hello,

I have a data set that refreshes every day to provide me with the stock value of different items in inventory. It breaks these down line by line based on the item. 

I am trying to get a sum of the total value of all the inventory, and show how that value changes over time. However, the data set refreshes to only show the value on the date/time it was refreshed. 

How can I store the total value of the inventory every day, so that I can show that trend in a graph? My data set includes a column that shows the date/time that the data refreshed. My thought process was to figure out how store the total inventory value based on the date in that column. Not sure if that is the best way to do this but open to ideas. See the attached picture. Thanks!

[Anonymous]

Hi @beanandrew18,

Based on your requirements, we suggest you create a measure first to calculate the the total value of all the inventory:

DailySumBookValue= SUM('Table'[BOOK_VALUE])

Then you need to create a new table to store the total and date in it for further analysis.

Consider using the PowerAutomate for Power BI visual or scheduled cloud flow to get measure from power bi then insert data to your new table.

Then add the new table as source to your existing report, use the line chart to display the trend based on date and total value.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.