Date Time Add using the row above

[G_SAND]

Hi All

I have used the Alteryx help section on Date Time to understand how to add months to a date but am having difficulty applying it.

Here is my data set:

Tile Seq	Mat	Tile	Date	Total	Right_Date		Right_Date
1	ABC1	2	2018-01-01	4	2018-03-01		2018-03-01
1	ABC1	2	2018-02-01	6	2018-03-01		2018-04-01
1	ABC1	2	2018-03-01	8	2018-03-01		2018-05-01
1	ABC1	2	2018-04-01	10	2018-03-01		2018-06-01
2	DEF2	2	2018-01-01	1	2018-02-01		2018-02-01
2	DEF2	2	2018-02-01	2	2018-02-01		2018-03-01
2	DEF2	2	2018-03-01	4	2018-02-01		2018-04-01
2	DEF2	2	2018-04-01	8	2018-02-01		2018-05-01

The first 'Right_Date' column is what I already have, and the second is what I want to achieve.

Based on either the change in Tile Seq N# or MAT number I want to add a month from the first date in the right date column and continue down until we reach the next Tile Seq or MAT number.

Another one that I am sure is easy but I just can't get to function.

Thanks

[LordNeilLord · Accepted solution]

Hi,

Multi-Row formula is your friend here:

[G_SAND]

Thanks @LordNeilLord

It was the 'IsNull' bit that I was missing - I'm sure I'll learn one day!

[G_SAND]

Next Challenge

I thought I would at least give this one a go myself but I can seem to get it working.

Now I have the date  part right, I now want to bring in the corresponding total for that specific date

Tile Seq	Mat	Tile	Date	Total	New Date	New Total
1	ABC1	2	2018-01-01	4	2018-03-01	8
1	ABC1	2	2018-02-01	6	2018-04-01	10
1	ABC1	2	2018-03-01	8	2018-05-01
1	ABC1	2	2018-04-01	10	2018-06-01
2	DEF2	2	2018-01-01	1	2018-02-01	2
2	DEF2	2	2018-02-01	2	2018-03-01	4
2	DEF2	2	2018-03-01	4	2018-04-01	8
2	DEF2	2	2018-04-01	8	2018-05-01

I can't use an If Row+X:Date as it can vary between materials.

Another easy one I'm sure

[LordNeilLord · Accepted solution]

Hi,

Use the summarize tool to sum the value against each date (grouped by Tile Seq & Mat) then join the streams back together.