Hi @Lisa Kruger
You can refer to the content in the following link, which may be helpful for your question.
https://www.sqlshack.com/time-intelligence-in-analysis-services-ssas-tabular-models/
https://aniruddhathengadi.blogspot.com/2011/03/how-to-calculate-ytd-qtd-mtd-and-wtd.html
Best regards,
Percy Tang
If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.