cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tiff Regular Visitor
Regular Visitor

save value at every update

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 ! Smiley Wink

 

Thanks a lot for your help ! Smiley Happy 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: save value at every update

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
sokg Established Member
Established Member

Re: save value at every update

Tiff Regular Visitor
Regular Visitor

Re: save value at every update

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 ? Smiley Happy 

 

Thank you ! 
Tiff 

Community Support Team
Community Support Team

Re: save value at every update

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

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