Need help on creating column that stores dates

[Nepal101]

Hello, I hope I can get some help on this Problem. 
There is a logic where if the value in a  column changes from "No" to "yes" then we need to record today's date and if some rows changes in different date it should show that date. 

client	Present	the date that changed from No to yes
A	Yes	8/12/2022
B	No	blank
C	Yes	8/13/2022 ( if the Present will change from No to yes tomorrow then display tomorrow's date.

We were able to create a formula by using 
 test = If ( Present= Yes, today()) but it just shows all the dates in today's date without saving the previous record. 
how can we do that where we can save the date as the changes happen? 
I would really appreciate it if you can help with this. 
Thank you for your time. 

[ChristianDGreat · Accepted solution]

Im not sure if this is possible in Power BI only.
This needs to be taken care of outside Power BI.

If this is stored via Sharepoint list this is possible since you can just look at the modified date.