Static date recording

[Anonymous]

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.

[v-piga-msft]

Hi @Anonymous,

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

[Anonymous]

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]

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?