Multi Row Formula Help

[dquimby]

Hi - I've been struggling with this for a couple of days so any help would be greatly appreciated. I have a data set with an event ID, Close of Business and Event Severity (and a million other fields). I want to write a calculation where I can tag an event ID when the severity changes from one month to another. I've tried the formula tool, the multi row formula and a bunch of other things and can't seem to get my desired output. 

Event ID	Close of Business Date	Event Severity
44433	2020-06-01	Medium
44433	2020-07-01	Medium
44433	2020-08-01	Medium
44433	2020-09-01	Medium
44433	2020-10-01	Low
55513	2020-06-01	Medium
55513	2020-07-01	Medium
55513	2020-08-01	Medium
55513	2020-09-01	Medium
55513	2020-10-01	Low

The end result would be to plug my data set into tableau and for any given reporting month, show a table like this:

 

My thought process is that I would need to flag the Event ID 44433 and 55513 in the 2020-10-01 and 2020-11-01 rows but I haven't been able to get that to work in conjunction with my tableau view. any suggestions?

Thanks in advance. 

[PhilipMannering]

Hey @dquimby 

Maybe something like this?

[PhilipMannering · Accepted solution]

Or if you wanted to label change to before and after, then it's a minor change...

[messi007]

Dear @dquimby,

Please check the workflow below:

Attached the workflow as well.

Hope that helps.

Regards,

[dquimby]

@PhilipMannering 

Yes! Thank you so much. So simple. Now I just need to create a calculated field in tableau so when I filter by reporting month, the current and previous months are in the view. 

Thanks!