Forum Discussion

Nepal101's avatar
Nepal101
Icon for Helper III rankHelper III
4 years ago
Solved

Need help on creating column that stores dates

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 
AYes8/12/2022
BNoblank
CYes8/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. 



 

Need Help
Show and Tell
  • ChristianDGreat's avatar
    ChristianDGreat
    4 years ago

    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.

1 Reply

  • ChristianDGreat's avatar
    ChristianDGreat
    Icon for Resolver I rankResolver I
    4 years ago

    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.