Query Date Formula

[erhan_79]

hi there ;

i need your kind support for below issue 

i have a date typed column on query side , near this column i want to create a new column which includes 1 day earlier data then my date column

you can what i need as below wtih right new date column 

thanks in advance

[amitchandak]

@erhan_79 ,

As a new column

new date = [Date] -1

[erhan_79]

hi @amitchandak  @Anonymous 

 i want to create a new column on the power query side   , but when i add a custom column with below formula ,  it gives below error 

[amitchandak · Accepted solution]

@erhan_79 , That was dax in M try like

New Date = [Date] -duration(1,0,0,0)

or

New Date = [Date] -#duration(1,0,0,0)

[Anonymous]

HI @erhan_79 

Create a column

New date = [date] - 1