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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.