Showing results for 
Search instead for 
Did you mean: 
JRamirez135 Frequent Visitor
Frequent Visitor

Static date recording



I was hoping someone could assist... I'm trying to record a static date, fromt the picture the logic is very simple... the column Int.Cert.Attain.Date will record the date when any of the PL values become "Int." this date needs to remain with the same value, I tried the date and now functions but they are volatile functions and update when my file is refreshed.









Community Support Team
Community Support Team

Re: Static date recording

Hi @JRamirez135,


What about creating a calculated column or a custom column which are static?


If you create the calculated column, you could use the formula below.


Int.Cert.Attain.Date =
IF ( 'Table'[PL] = "Int", TODAY (), BLANK () )


You could change Today() to any date you want it to display.


If you still need help, please let me know.


Best Regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JRamirez135 Frequent Visitor
Frequent Visitor

Re: Static date recording

Hello Cherry 


Thanks for the response, would the date remain with the same value or would it change every time the datacollection is saved and opened again. I need a time stamp when the PL column becomes Int. 


Thanks once again

adambhappy Regular Visitor
Regular Visitor

Re: Static date recording

The calculated column would be evalatued each time the dataset is refreshed.


This isn't something that you should try to achieve in the Power BI since the ETL is executed each time the dataset is refreshed and it doesn't persist data beyond the results that are calculated at runtime.

Where is the source data stored?

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 394 members 3,652 guests
Please welcome our newest community members: