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 and error.

 

thank you

 

Richard

Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    this functions

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

    control your parenthesis

     

3 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    Hi,

    this functions

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

    control your parenthesis

     

  • cottrera's avatar
    cottrera
    Post Prodigy
    3 years ago

    Great works fine thank you for responding so quick;y ğŸ˜€

  • 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.