Power query refresh

[Dominikx1]

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]

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]

I found a problem, the date cannot be e.g. 30/01/2023 only instead of . must be - just how to replace . on -

[Dominikx1]

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