save value at every update

[Tiff]

Hi everyone ! 

I have a question, and I have no idea about how to do this in power BI...

Every month, I update my power BI with a new Excel. 
Each month, I've a quantity that I'd like to save. 
But at each update, Power BI add the quantity, without saving the quantity before the update. 

Is there a way to save the quantity each month in another table ? 

Please, tell me it's possible (I don't even care if it can't be automated ! 😉 ) 

Thanks a lot for your help ! 🙂 

[v-lili6-msft · Accepted solution]

hi, @Tiff

I'm afraid it couldn't achieve in Power BI for now, But you can do it in data source like backup the data before you refresh in Power BI.

Best Regards,

Lin

[sokg]

Please read this:

https://exceleratorbi.com.au/keeping-track-of-changes-on-a-website-power-bi/

[Tiff]

Hi, 

Thx for your answer, I read your link. 
However, I couldn't find what I want (even if I learned plenty of things !) 

To rephrase myself, I'd like to extract the sum of a column in another table.

Just like this, I will find a solution to my problem. Is there a way to do this ? 🙂 

Thank you ! 
Tiff