Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 ...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    adambhappy
    Icon for Resolver II rankResolver II
    7 years ago

    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?