New data monitoring

[leonardof]

Hey people, how are you?

A have a form that insert data into a database and I don't have a column showing the date that the form was filled. I have a report in power bi that is connect with that database. Is there any way possible to include in my report a date column wich gives me the date that the form was filled? Or better yet, the date which that data was insert in the report?

Thanks

[v-tangjie-msft]

Hi @leonardof ,

You can use the Power Query Editor in Power BI Desktop to add a custom column that contains the current date and time using the `DateTime.LocalNow()` function.

Refer : Add a Custom Column Containing Today's Date - Microsoft Fabric Community

DateTime.LocalNow - Function | Power Query How

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.