I'm not sure what version of SQL that my BI tool rides on (Sisense).  I was looking through it for any solution and the only thing I found was self-joins to solve my issue and it drew me back to this site to ask the question.