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.
Hello, is it possible to make power query refresh the data and change the date to local? Because every day comes a new date and needs to pull out the current one
hi @Dominikx1 ,
using the below statement provides the date from your locale :
Date.From(DateTime.LocalNow())
You could use this in a filter step, where the filter is equal to the above to filter today's data.
Alternatively, you could create a query with this value and reference the filter to the query's name if you want.
When you hit refresh now it should bring in only from that date.
Appreciate a thumbs up if this is helpful.
DateTime.LocalNow - PowerQuery M | Microsoft Learn
Let me know if this resovles your question.
I found a problem, the date cannot be e.g. 30/01/2023 only instead of . must be - just how to replace . on -
Hello, I used the solutions you posted with "" and without "", the result is the same as in the picture and when I add {""} it pops up null
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.