Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

POWER QUERY FEATURE YESTERDAY

Nice day.

I would like to know if there is a way to add a column in Power Query with yesterday's date.

Thank you!

  • The formula I used was as follows:

    Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1))

1 Reply

  • The formula I used was as follows:

    Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1))