Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add column with previous month value

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.

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous ,

    new column =

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous ,

    new column =

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.