Forum Discussion
Anonymous
3 years agoNot applicable
Previous date
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
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
1 Reply
- amitchandak
Super User
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