These are just a few quick thoughts as it's hard to know without seeing the data. You want a time period comparison by running total, correct? You could start by placing [Period Number] on the rows shelf, YEAR(Date) on the columns shelf, and then whatever metric you are comparing on the Text Marks card? This would show the amount per period per year. You could then right click on your metric and select "Quick Table Calculation" and "Running Total". Lastly, you would right click on the metric again and select "Edit Table Calculation" and click the box for "Add Secondary calculation", then pick "Difference from" to get the year over year change.
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I have the same issue - did you ever figure this out?
I have removed the detailed calculation mentioned in the message,
I made a few changes to the logic and included calculation of total sales for Period to Date
twbx and dataset are in the attachment
Hope this meets your requirement
Thank you very much for the feedback. Being an Accountant, I have taken care of leap year as well.
If it helped you solve the puzzle, could you please mark it as "Helped: