Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
3 years ago
Solved

Power Query Todays date minus 1 day

Morning      I need to create a custom column that dsiplays Todays date minus 1 day.  I thought it might look someting like this =Date.AddDays(DateTime.FixedLocalNow())-1   but this dispalys an...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    this functions

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

    control your parenthesis

     

AlB's avatar
AlB
Community Champion
3 years ago

Hi cottrera 

 

Date.AddDays(Date.From(DateTime.FixedLocalNow()), -1 )

 


 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.