It's commonly used to:
* Dedicate a piece of work (like a book, poem, or song) to someone who has passed away.
* Mark a memorial or tribute to a deceased person.
* Appear on tombstones or memorials.
Essentially, "in memoriam" signifies that something is being done to honor and remember someone who has died.