in Table Calculations - find distinct value AND last instance of duplicate values

[zachinoz]

I have a column of values where, in table calculations, I need to identify in another column whether that value is distinct, and if it isn’t, identify the last instance of that duplicate value.

[zachinoz]

https://community.looker.com/explores-36/using-table-calculation-functions-and-operators-to-create-w...

Answered with use of above link.