Add column with previous month value

[Anonymous]

Hello,

I am looking to add a column to a table that shows the [Due Date] from the previous month. I have a date table that is linked to the [Import Date] column in the table. 

Any help on how to do this would be much appreaciated.

[Anonymous]

Thank you @amitchandak  thats great.  did have to change the column it filters to [Site_Task] as [Site] is not unique due to many tasks at each site.  

[amitchandak · Accepted solution]

@Anonymous ,

new column =

maxx(filter(Table, [Site Name] = earlier([Site Name])  && [Import Date] <earlier([Import Date]) ) , [Due Date])