Get today's date with your format in Power Query M formula language.
Source code viewerDateTime.ToText(DateTime.LocalNow(), "dd.MM.yyyy")Programming Language: Text