Changing value of specific cell in column

[Anonymous]

Hello,

I am beginning to learn Power BI, and i am trying to figure out how to change the value of a specific cell in column according to another value in the same row.

My source is a csv file and a list of dates. What i want to do is only fill the "Stock CEM" cell of the actual day (by actual day i mean today). Then, tomorrow, the csv file will be updated and the "Stock CEM" number will get updated and i would like this new number to be displayed next to the date of tomorrow, and so on and so on..

I don't know if there is a DAX formula that allows me to do that, i feel like i'm missing something

It would be really great if you could help me !

Thank you in advance,

[amitchandak]

@Anonymous , see if this can help

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

[Mariusz]

Hi @Anonymous 

Not sure if I understand what you need, but if you are planning to somehow keep prior  to the refresh then Power BI was not designed to do this sort of thing and probably you will be better of trying to capture it at the source.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn