Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Changing value of specific cell in column

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..

LouisO_0-1593677283651.png

 

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,

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , see if this can help

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Mariusz
Community Champion
Community Champion

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

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!