Forum Discussion
Solved
Get max date from all the previous date
I am trying to get the maximum of all the previous dates based on the selected date, I try to create a column but it returns null; this is what I want to do: I have to add a new column to my table ...
Hi, rima_ch
You can try formula as below:
Previous = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] < EARLIER ( 'Table'[Date] ) ) )If it can't meet your requirement, please share you sample file for further researh.
Best Regards,
Community Support Team _ Eason
