Stock updates on an overwritten basis

[Syndicate_Admin]

Good!!

I'm having a problem in Power BI. I have my Stock table that is updated daily and overwrites all the values, that is to say that it does not save a history of the stock per month / day, is there any possibility of configuring power bi so that the last day of each month freezes that information as if it were "a photo" to save the history?

Thanks a lot.

[Syndicate_Admin]

Hi, we are using SQL

[andhiii079845]

Than you have to create a SQL Procdure which insert the new data in a existing table with the older entries. Use a column like "importdate" to seperate the different data.

[Syndicate_Admin]

Ok serves me, what happens is that previously this information if it was saved in QLIK (program that was stopped using and migrated to PB) then we wanted to replicate that. Thanks a lot

[andhiii079845]

Sorry, but i do not understand it. Please explain it again.

[andhiii079845]

I think it its not possible to do it in PowerBI. the only possibilty is to create a history mechanism before (like in SQL). 

What Datasource do you use?