PowerBI record date

[ye348]

Hi all im wondering if theres a way in powerbi to write a function that can record dates and log them below is an example i have where i have a date column that just generates todays date whenever the "install status" column reads "installed". the only problem is that with this method i can only generate todays date each time one of the install status's switches. which is why im trying to see if theres a record function or a way to log whatever value shows up in the install date column so that i can show a varity of dates and not just todays date

install status	install date	record date?
Not installed
Installed	8/15/2023
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
Not installed
installed	8/15/2023

[devesh_gupta · Accepted solution]

@ye348  

DAX append may help: 

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

If you find this insightful, please provide a Kudo and accept this as a solution.