Forum Discussion
Solved
Previous date
I want previous sys date
So how to create custom column for that
Vishal_2202 , DAX
Date = today() -1
Power Query
=Date.AddDays(DateTime.Date(DateTime.LocalNow()),1)
Check
https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X
4 Replies
Vishal_2202 , DAX
Date = today() -1
Power Query
=Date.AddDays(DateTime.Date(DateTime.LocalNow()),1)
Check
https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X
I want that in custom column so I can make another custom column with it.
Vishal_2202 , yes the code is for custom columns only
Power Query formula works just a small correction there should -1 instead of 1.
Thanks for help
