Forum Discussion
Power Query - trying to add a column that compares a date from one column with today's date?
I am trying to add a column in Power Query, and I am trying to compare todays date with a column in the workbook which has a date. The output should be the number of days difference between todays da...
Hi Anonymous
create a custom column
Date.From(DateTime.LocalNow()) - [YourDateColumn]
az38
Community Champion
Community ChampionHi Anonymous
create a custom column
Date.From(DateTime.LocalNow()) - [YourDateColumn]Worked perfectly!!! thank you so much