In power query, we don't use today() function to get current date you can try this below function to get current date
= Date.From(DateTime.LocalNow())
then replace the formula with your today() function in your M coding and have a try
enter link description here