Forum Discussion
Calculate monthly amount based off yearly data
Hi dadadaeerz,
Did you have date column in your dataset? As I know, we could calculate YTD based on correconding month. But you want to calculate MTD based on year, I can't reproduce your requirement based on your description, so if possible, could you please inform me in details(such as your data sample)?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks . I don't have the actual date for each month included in the dataset, although I could transpose it to be included. I am currently using a MM-YYYY field. The year-end is currently October 31st, but will soon be changing to December 31st, and so if I did transpose it, I would use a table so that I could later change it. I do have a table that I am using to calculate the previous month's period value - I have a fiscal year column that differs than the calendar year value, and could add a fiscal year month if needed.
Here is the period table:
Thanks!