Forum Discussion
jcastr02
Post Prodigy
Post Prodigytoday button in conditional column
Does anyone know if the today button here date change as the day changes . Id like the conditional column to use TODAY()'s date or is that date selected hard coded and stays the same the next day. ...
For that kind of logic, it is easier to do it as a calculated column with DAX so you can actually leverage from TODAY() function. In Power Query it would be hardcoded, but you can leave a Date as a placeholder and modify the M code to use Date.From(DateTime.LocalNow()) to use "today's" date.
ray_aramburo
Super User
Super UserFor that kind of logic, it is easier to do it as a calculated column with DAX so you can actually leverage from TODAY() function. In Power Query it would be hardcoded, but you can leave a Date as a placeholder and modify the M code to use Date.From(DateTime.LocalNow()) to use "today's" date.