Previous date

[Anonymous]

Hello Everyone,

I have one existing date column and i want to create one new date column based on that existing column and this new column is previous date column.

i.e  date                previous date

   05/05/2023    ->   05/04/2023

  05/06/2023     ->   05/05/2023

so how i can achieve in power bi 

Thank you

[amitchandak · Accepted solution]

@Anonymous ,

A new column

= maxx(filter(Table, [Date] < earlier([Date]) ), [Date])

refer

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s