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

Static date recording

Hello,

 

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.

 

Capture.PNG

 

 

 

 

 

 

3 REPLIES 3
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,

Cherry

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?