Generate ID based on chaning dimension

Hello,

I need to generate an ID based on the changing status, like in the example below.

Each ID must be based on a fixed text including the first date-time field when the status changes.

Anyone an idea how to do that?

13-Mar-18 09-50-18.png

Accepted answers

Multirow again for this one! Read up about Multirow, it's super powerful

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

Multirow again for this one! Read up about Multirow, it's super powerful

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

@LordNeilLord am I right in thinking the data needs to be sorted prior to the multi-row else this may cause issues?

Ben

Perfect! Thanks again for your help!