Add column with previous month value

[reidnmorrison]

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.

[reidnmorrison]

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]

@reidnmorrison ,

new column =

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