How to buil info with historical values

[jmvidal]

HI,

I want to keep track of the evolution of stocks.

Today I capture a table from our ERP with:

currentdate, product, stock, value

Is there any way I could store this info so I could get the evolution of stock? something like:

2020-04-15, product, stock, value
2020-04-16, product, stock, value

etc

Thanks!

[v-gizhi-msft]

Hi,

Do you have any date column when capture these data from your ERP like this?

If not, can you capture the data import Date by other way?

When you successfully capture this date everyday, try to create a calendar table first.

Then you can easily make a comparsion between calendar table date and this import date that if equals, return three columns data.

Best Regards,

Giotto

[amitchandak]

@jmvidal , Refer if this can help

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[jmvidal]

Thanks for your answer.

I am afraid this is not what I need: as far as I understood, having two tables and make a union with them might work when having historical data and recent data, in order to avoid loading large quantities of rows.

I my case, I need to keep yesterday's rows, then add today's rows, then add tomorrow's rows and so on, because I need to know (in my example) the stock I am having every single day and see the evolution.

Thanks!