Forum Discussion
Dominikx1
3 years agoFrequent Visitor
Power query refresh
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
adudani
3 years agoMemorable Member
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.
Dominikx1
3 years agoFrequent Visitor
I found a problem, the date cannot be e.g. 30/01/2023 only instead of . must be - just how to replace . on -