Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create a custom column in a load query that reflects the date the data was loaded, but when attempting to use Today() or Now() an error is returned. How should this be done?
In the query, create a new column and use
DateTime.LocalNow()
From:
In DAX, use:
=TODAY()
Of course, that would be a bad idea to use TODAY() in DAX for what you want, as I am sure you have already realized.
How to create a column containing today's date depends on the source of the query. If the query is from SQL Server the query would be something like Select column1, getdate() as Loaddate from tableY
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.