Previous date

[Vishal_2202]

I want previous sys date 

So how to create custom column for that

[amitchandak · Accepted solution]

@Vishal_2202 , DAX

Date = today() -1

Power Query

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

Check

https://www.youtube.com/playlist?list=PLPaNVDMhUXGZdm-2DIMrS54Z2J0TAxj0X

[Vishal_2202]

Power Query formula works just a small correction there should -1 instead of 1.

Thanks for help

[Vishal_2202]

I want that in custom column so I can make another custom column with it.

[amitchandak]

@Vishal_2202 , yes the code is for custom columns only