Hello erverybody,
I have created a table in power query and could filter by a "DATE".
Here I´m filtereing column "DATE" for all values, that are earlier that 29th March of 2021.
= Table.SelectRows(#"Umbenannte Spalten", each [DATE] < #datetime(2021, 3, 29, 0, 0, 0))
Unfortunately I have to change this ervery time, when I´m open the file manually.
Is there any chance, to link this automatically to the current day, like a simple Excel formula like "=today()" ?
Best wishes to you all 🙂
Hello,
Check out this function.
https://docs.microsoft.com/en-gb/powerquery-m/datetime-fixedlocalnow
Br,
Anders
Hello Anders,
thanks a lot for that function. 🙂
At the beginning I got a lot of errors, and was not able to understand the reson, but now it works 🙂
= Table.SelectRows(#"Umbenannte Spalten", each [DATE] < DateTime.FixedLocalNow())
