IF Conditional Column = "text", then add a timestamp

[OliverJonesP1]

Trying to determine how long each status is in production. If "Status" column = "shape in progress" how do I datestamp it when it moves into this status?

I am using Date.Time Fixed Local Now, but everytime I refresh the query, the date updates to today's date. I need the date to stay at the date it moved into the status and not change to today when I refresh the data.

[HamedM1125]

@OliverJonesP1 

I tend to beleive it is not possible, but can you share a sample dataset (excel) and the expected out put?

[marcelsmaglhaes · Accepted solution]

Hey @OliverJonesP1 ,

I think is not posible maintaining a timestamp that doesn’t update on each refresh, since Power Query recalculates values whenever it refreshes.

To achieve this, you generally need to either store a static timestamp outside of Power Query (e.g., in a database or by appending new rows in Excel).

Sorry for that!