Forum Discussion

Tiff's avatar
Tiff
Helper I
7 years ago
Solved

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 ! ;) ) 

 

Thanks a lot for your help ! :) 

 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

3 Replies

    • Tiff's avatar
      Tiff
      Helper I
      7 years ago

      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 

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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