Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.